Using MS SQL Server

Load XML souce file to a SP parameter
I have a proc like this (T-SQL, SQL Server 2000): Alter Proc ImportXML @chvFullFileName varchar(200), @txtInputXML text='' AS My question is how can I load the contents of the XMLFile into the parameter called @txtInputXML ? Let us say my full file path is C:\XML\SampleXML.txt. I want to load this into param... 3 May 2006 03:40

Timeout errors
After executing osql from the command line via the Windows scheduled task interface, the following error is returned: "Timeout expired" The code in the sql is as follows: BACKUP Database DBName to DISK='D:\Files\Backups\DBName.bak' WITH INIT go Is the timeout happening during the backup or in just connec... 12 Jun 2006 17:54

Auto Number
Hi, I want to create a random unique auto generated number. dont want to use GUIDs. Any other way to create it in isert statement itself, apart from storing a number in a table and increment while inserting. Help me! ... 8 Apr 2006 06:11

SQL server express 2005 local accounts problem. please help!
Hi all, After working for weeks on a project in VB.Net, I decided to deploy a test version on a user's computer. The user's XP SP2 computer has sql server xpress 2005 installed, and my VB.net creation. Everything works without problem when the user's XP account is set with Administrator permissions. But when i... 6 Apr 2006 18:31

SQL Server 2005 vs Oracle
Anyone know where I can find some good resources to help us choose between SQL and Oracle ( Progress Openedge as well ) . Any comments on what you would choose ?? We are creating a new Warehouse Management System which wil manage our very large inventory. Anyway comments suggestions welcome Thanks Paul ... 17 Apr 2006 11:56

Math functions
Hi, How to find the list of SQL math functions in SQL Server 2005? Thanks Kai ... 1 Apr 2006 01:05

Transpose Rows to Columns ?
I have records ID Sku Name Date 2 41 Blair 01/04/03 3 45 John 03/04/03 that should look like... ID 2 3 Sku 41 45 Name Blair John ..... and so on. Number of source rows will be fixed (12) so no of target columns will be 12 too. Anyone k... 29 Mar 2006 23:48

open MDF file without MSDE
Hello, I'm trying to access .mdf file (a sql server database) without having SQL Server installed on the machine (neither MSDE). It can be done from any programming language (like Java or C#)? Is there anyone who knows how can I do it? Or does a native library that can access the .mdf file exist? Thank to anyon... 22 Mar 2006 11:11

Delete Many Rows
Hi All, I am designing a purge process for a db that has grown to almost 200GB. My purge process will remove about 1/3 of the 500 million rows spread over seven tables. Currently there are about 35 indexes defined on those seven tables. My question is will there be a performance gain by dropping those indexes, ... 22 Mar 2006 13:49

Optimization jobs - transaction deadlock victim
I am running SQL Server 2000 SP4 (w/AWE hotfix) on a 32-bit Windows 2003 Server (SP1). I am trying to run an Index defrag and rebuild job. It has worked fine in the past, but lately I'm getting this: Msg 1205, Sev 13: Transaction (Process ID 73) was deadlocked on lock resources with another process and has ... 10 Mar 2006 18:35