Using MS SQL Server

Error message on using union statement with order by using reserved words
Hello, The part of my stored procedure giving me problems is this: *********************************************************************************************************************************** --------------------------------- -- FINAL OUTPUT - Two Record Sets --------------------------------... 10 Nov 2007 08:23

Solution: Invalid STDGMEDIUM structure error in DTS package
This morning I got the following error from a DTS package which had been running happily for months (we're running SQL Server 2005 (64- bit)): Invalid STDGMEDIUM structure error [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrectl syntax near ')' I couldn't find the solution online, but I did figure it ... 17 Oct 2007 18:31

SQL 2005 Ambiguous column name
I have a strange issue and was hoping somebody could explain. The below query gives an ambiquous column name error on an install of SQL 2005 Standard, sp2. This same query works fine on another install of SQL 2000 Standard sp4 and SQL 2005 Workgroup. The order by clause is causing the error. I know this is ... 5 Oct 2007 15:32

how much space to allow for log files??
I am setting up a SQL server to be the backend for a SharePoint Services 3.0 server. I"m allocating about 75 GB for the data files on one drive. How much should I allocate on another drive for the log files?? I was thinking 5 GB should be enough?? Thank you, Tom ... 10 Jul 2007 10:16

Reading a directory
I do a lot of file processing and I usually run a little script I copy and paste to read directory information to see if a new file it there and then process the file if it is. So, I decided to wise up and make a stored procedure to automate a lot of that. The pivotal step in this is that i run a command that lo... 28 Feb 2007 18:37

SQL Server Link Server
Is it possible to create a link server in SQL Server without using the default system.mdw file? Any help is appreciated. Thanks. ... 19 Feb 2007 18:51

xp_cmdshell sql server 2000
hi, does anybody know how to enable/disable xp_cmdshell in sql server 2000. i our server this sp has been disbaled for security puropse.but i need to use it in a job.so please can any body guide me? thanks for the help. -Shark. ... 8 Feb 2007 18:34

Converting a varchar to int
I am struggling with converting a certain varchar column into an int. I have a table that has 2 fields - one field holds the loan number and the other field holds the codes associated with that loan number. Here's some example data: Loan# Codes 11111 24-13-1 22222 ... 12 Dec 2006 23:48

DBCC Memory Status and Query Plan
When I executed DBCC Memory Status following are the out put Buffer Distribution Stolen 187191 Free 1026 Procedures 6698 Inram 0 Dirty 154661 Kept 0 I/O 0 Latched 772 Other 436084 Buffer Counts Committed 786432 Target 786432 Hashed 591517 Internal Reservation 510 External Reservation 2291 Min ... 26 Oct 2006 20:30

Snap-in creation failed
Hello I have SQL Server 2000 on my laptop. I installed VS 2005. Now when I go into Enterprise Manager for SQL 2000 I get an error message Snap-in failed to initialize;Name <unknown>;CLSID {a bunch of numbers}. When I click ok, it loads Enterprise Manager with a message Snap-in Creation Failed. Thanks Sali... 29 Sep 2006 14:38