Question MSDE: Query Analyzer vs MSAccess ADP

Hi all! I have one UDF which take 5 params. When I run this UDF from Query Analyzer, it take 5 seco…

Optimize Query

hI all, I have a table A with fname, mname,lname , radd,odd etc. Similarily i have table B with sam…

Administration

One of my table with 50 columns contains 3,43,416 records. While i give "select * from table_n…

raising error in execute sql task

I have an update statement i run at the outset of my dts process. Is there a way to raise an error …

Our Gang

Not all 260,000+ people, but we did get 4 of the SQLServerCentral.com community together for a phot…

SQL Transaction deadlock

  Has anyone ever seen this error?  I get this error about 40-50% of the time when I run …

Syslogins and passwords

NOLOCK question

I've inherrited a database where a large number of views and procedures use NOLOCK. The history is …

separat word

how to separate sentence "Eko Indriyawan Lagi Makan" into four field become like this :   fiel…

Accessing DTS Constants from VBScript not running with DTS

I am writing a Windows Script Component File that will wrapper up some common code that I want to e…

Contract Job for Sydney Australia (SQL DB Admin)

We are looking for a SQL Server 2000 DB Admin to help trouble shoot some issues we are having with …

Determine column name

I am entering some data on client of a client server application. How can I find out in which colum…

Greetings from PASS

I arrived in Dallas today after an uneventful flight (the best kind to have!) from St. Louis. …

I hope someone will help me with xp_cmdshell

Check the below link http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messagei…

I hope someone will help me with xp_cmdshell

Check the below link http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messagei…