Viewing 15 posts - 31 through 45 (of 77 total)
SQL Server is pretty nifty at sending emails as longs as you use Exchange, do a search on "SQL Mail" on books online for starters. From memory the Exchange client...
April 27, 2005 at 3:48 am
Also, the SQL Enterprise Manager 'Generate SQL Script' tool is damn good! I would definitely use this even if you only use the generated scripts as backup (e.g. to drop...
April 26, 2005 at 3:58 am
That link says it all really!
(i) Be careful with collations. We've had tempdb problems with migrated dbs when the Server and db collations differ. (SQL_Latin1_General_CP1_CI_AS vs Latin1_General_CI_AS). This may happen...
April 26, 2005 at 3:54 am
The DTC Service is running but the associated Message Queuing service hasn't been installed for some reason - this is almost certainly the problem. I will check with the guy who...
April 26, 2005 at 2:15 am
Yes, the RPC sets up parameters and calls the remote procedure in the form 'EXEC server.db.owner.proc', passing a mix of varchar and numeric params.
April 25, 2005 at 9:24 am
The username should be at the end of the error message.
April 25, 2005 at 9:21 am
I think you are making this more complicated than you need to. As the message implies, the client is trying to connect with a loginname that has not been set...
April 25, 2005 at 9:19 am
We use XML all over the place not because we need it, nor because it's better than other ways of retrieving data but because 3 years ago it was hot and...
April 25, 2005 at 8:28 am
How about selecting every column apart from the identity cloumn into a temp table, inserting into the temp table using a SELECT DISTINCT, truncating the main table then inserting the contents...
April 25, 2005 at 7:40 am
Oh no! Sounds like my nasty-and-illadvised-but-very-useful fixes to system tables may not work under SQL 2005!
A slightly more elegant and safe option than updating sysobjects is to use it to...
April 22, 2005 at 8:49 am
I tend to ignore the taskbar, it can be misleading. In fact, it's hard to find out any info on the progress of a database restore while it's happening (e.g....
April 22, 2005 at 3:13 am
I enjoyed this piece too, particularly the consultant sketch - very true and very recognisable! There must be an interesting psychological study behind why managers trust consultants so much and why...
April 19, 2005 at 3:39 am
Mark
I think you and Prithiviraj have taken this as far as you can. You have to execute the identity check on the remote SQL Server (SQL2) and pass the result...
March 24, 2005 at 9:27 am
Bill Gates' knighthood got a fair bit of publicity over here in the UK. Apparently the previous evening the Queen had hosted a bash for the music industry where she was introduced...
March 3, 2005 at 6:38 am
I would generate a script on the database to be cloned, create a new db and execute the script on that DB.
In SQL EM, right click on the db to...
February 18, 2005 at 9:13 am
Viewing 15 posts - 31 through 45 (of 77 total)