Database

jschell wrote: If you don't trust your users then either address that at the management level or the contract level. And don't try to solve it with technology. :thumbsup::thumbsup::thumbsup::thumbsup::thumbsup: That's got my five. Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

Mycroft Holmes wrote: The second greatest scam I have worked for some CIO's that have come up with way more atrocities than ETL or Y2K. Mycroft Holmes wrote: Extract - Load - Transform simplifies and speeds up the entire process. I think you can write bad code / processes in any language or tool. It's up to the person to find the best way to do it that works for them. Not sure about you but I have some amazingly fast SSIS packages that load a gig of data in seconds, but have seen some others that take hours doing a lot less data. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

At the most basic, you're talking about Soundex matching, which isn't great. You might want to consider Full Text Indexing, which will return misspelled items if they are close enough. Of course, you can always implement your own fuzzy logic inside SQL Server, using CLR functions. *pre-emptive celebratory nipple tassle jiggle* - Sean Ewington "Mind bleach! Send me mind bleach!" - Nagy Vilmos CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Eddy Vluggen wrote: ..and no, it's generally not a good idea to have a server open like that; it's obvious that you're running Sql Server, and one can request a list of all the databases in there. From the question I would guess that the OP doesn't own the database server.

Absolutely!

You can also user the SQL import Export wizard to transfer the data from one database to other database either table wise of bulk

Try logic; you renamed it? Drop it, and create it anew? Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]

Add Group By ProductName, Field2 after the where clause Never underestimate the power of human stupidity RAH

Dan_K wrote: Now I need to grant permission :confused: Is some kind of permission problem ocurring now that wasn't occuring before? Maybe I'm missing the obvious. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

What have you tried?

Use SymmetricDS: http://www.symmetricds.org/[^]

(SELECT * from [db].[schema].[tbl] FOR XML PATH(''),ROOT(''))

Goto registry search for: 10.50.1600.1 by select F3.

grant server role with sysadmin :)

Now that I did not know, have 5 for he link, thank you, you have justified the rant... Never underestimate the power of human stupidity RAH

Don't write in capital letters - looks like you're shouting. Try the manual[^]. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]

jschell wrote: since zero and null are not necessarily the same thing The is always a debating point, do we allow null to represent a value in a numeric field? As I'm a lazy sod I disallow null in numeric field as my default position and until the business can convince me otherwise that is the way it is designed. Never underestimate the power of human stupidity RAH

that could be quite handy In Word you can only store 2 bytes. That is why I use Writer.

Super solution but can't be replicated in other databases like oracle. Identity is a near equivalent to rowid concept in Oracle but its a dynamic value i.e not a sequence generator . Hence may be Only possible in sql server. Regards Sreeni www.sreenivaskandakuru.com

no you do not have to(but it is a safer option)..Have a look at the following snippet..- USE AdventureWorks2008R2; GO -- Variable to store ErrorLogID value of the row -- inserted in the ErrorLog table by uspLogError DECLARE @ErrorLogID INT; BEGIN TRY BEGIN TRANSACTION; -- A FOREIGN KEY constraint exists on this table. This -- statement will generate a constraint violation error. DELETE FROM Production.Product WHERE ProductID = 980; -- If the delete operation succeeds, commit the transaction. COMMIT TRANSACTION; END TRY BEGIN CATCH -- Call procedure to print error information. EXECUTE dbo.uspPrintError; -- Roll back any active or uncommittable transactions before -- inserting information in the ErrorLog. IF XACT\_STATE() <> 0 BEGIN ROLLBACK TRANSACTION; END EXECUTE dbo.uspLogError @ErrorLogID = @ErrorLogID OUTPUT; END CATCH; -- Retrieve logged error information. SELECT * FROM dbo.ErrorLog WHERE ErrorLogID = @ErrorLogID; GO