sp_spaceused is not that accurate if u havent used DBCC UPDATEUSAGE for a while. But u should use sp_helpdb , so that u can get space of ur datafile...

I do see the options in SQL 2005 Dev edition service pack 2

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright...

In any language things can't happen by themselves. I am assuming another user has created table with the same name but with his schema.

isn't there a possiility that both the users have created same table with their prefix name? Thats all I can think of.

u can install both of them on the same m/c or box. The first installation will be called default instance and the other or second installation will be called named...

UNION is slower because there is more overhead by optimizer because it has to combine two result set into one set.

Theses r the things that are coming into my mnind. Can u run both of those separately.First run the DBCC command, when u see success in the bottom screen of...

Turn on your traceflag 2861

DBCC TRACEON(2861)

--yourfn_get_sql query

and Later on you can turn off your trace flag

DBCC TRACEOFF(2861)

The reason is handles expire very quickly and donot remain in cache. By turning...

Have u tried Bulk insert. Thats what we use for the big files.

In order to execute other multiple packages, “Execute Package Task” under control flow(In SSIS) needs, sp_dts_listpackages execute permissions. This package is in MSDB database and uses sysdtspackages table. So u...

Is it possible for u to stop the server at night time and then delete the file from error log where this Trace might be active?

Microsoft has divers for that. Some of them free, u can just search on their site and u may find one. Thats how we do here.

Yup,Decimal(x,y) is better

R the Remote connection to your M/C enabled. In Sql Server u can look in the properties of the server and check on that tab where it says enable remote...

DBCC INPUTBUFFER gives first 255 charracters only. U can use below query to get all the characters or completer query

DECLARE @HANDLE BINARY(20)

SELECT @HANDLE = sql_handle from sys.sysprocesses where spid...