Christian Buettner (8/7/2009)

---

If I am not totally wrong, the behaviour is not due to IsNumeric itself, but to the fact that you can cast this value to money or smallmoney.

Try...

WOW....WOW.....

Discussion board is much more interesting and knowledgeable than the article. Rarely we come across a thread where discussion lasts so long. Truly a good thread to start...

You created RemoteUser on both the servers. But on ServerA is this user mapped to the database you are trying to look data into.. Check if this RemoteUser...

Kaushik Kumar (8/6/2009)

---

Come on; such simple solutions are expected out of novice heads me not brilliant minds like you .... 🙂

Changing compatibility is not an option in most cases especially...

Thanks for the Article Steve. Very well explained. Was looking for this kind of article for some time where all information could be found in one place. ...

Schadenfreude-Mei (8/6/2009)

---

If anyone has the answer this would be useful. I have a 5gb msdb under sql2000. Not sure how it got that way but the thoughts are it...

Good scripts Adam. Thanks.

I had the same kind of request from users couple of months back to change Collation SQL_Latin1_General_CP1_CI_AS to Latin_general_BIN on a particular database.

Directly changing collation with Alter database command won't...

Try this. Works good on both 2000 and 2005.

set nocount on

declare @name sysname

declare @sql nvarchar(600)

/* Use temporary table to sum up database size w/o using group by */

create...

you can create it by using sp_attach_db command. Read BOL for more info.

Example here from BOL:

EXEC sp_attach_db @dbname = N'AdventureWorks',

@filename1 = N'c:\Program Files\Microsoft SQL...

Use this query to fill all orphan users on any database.

BEGIN

DECLARE @username varchar(25)

DECLARE fixusers CURSOR

FOR

SELECT UserName = name FROM sysusers

WHERE issqluser = 1 and (sid is not null and sid...

Agreed with Matt. Rule of thumb: Never use like operator on a very large table. It kills.

Go through this thread.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/23ab9559-9f34-4609-9fd1-cebd3df97b28

ROFL .... Your signature made my day.

2 Tim 3:16 (7/31/2009)

---

Mayne the user didn't get matched up with the login.

Go to Security - Login and look at the porperties for the login and see if the user...