If you were using the computer name and that name is not recognized on the local subnet then it may not be able to find it. We have run across...

Odds are the reason is because you had yourself in the context of master. In TSQL run

USE msdb

Go

then your restore items. I made this mistake previously. You should also do...

Here read this from SQL BOL

quote:

---

Prepared Execution

The ODBC API defines prepared execution as a way to reduce the parsing and compiling...

Yes FKs do not verify if the same columns exist in a different FK. Technically this doesn't break it so it does not cause an issue, just a pain to...

The big key being

Use paramater substitution so that the actual statement text remains the same.

If you use the metadata and change the column names or tables involved every run...

I prefer

while not dkrResult.EOF

response.write(dkrResult.fields("customerid").value)

dkrResult.movenext

wend

Also, check your Client Networking Utility for SQL if installed if you are using the defined name in the connection parameter that is stored in CLU. Make sure is a...

Ways I can think of off hand

DTS

Import/Export Wizard

Create linked server and query over

dump the data to comma seperate or tab delimited text file and bcp in

build an app to read...

Prakash is right as long as the transaction log is intact from the last time they did any backup then you could restore to another DB the last full, backup...

Duplicate post, see responses in thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8452&FORUM_ID=8&CAT_ID=1&Topic_Title=DATETIME&Forum_Title=T%2DSQL

Yes using '' on a column that is datetime defaults to the lowest value which is 1/1/1900. You need to insert with the keyword NULL in the position instead.

You cannot...

No, do not install SQL Server just the CLient tools using custom install. Yopu can choose not to install EM and QA in that situation I believe but still have...

In the SQL string I think is watch he means, add a space. WHen you apply it should generate a change in the view and perform an alter. However, I...

Cool the message if you click on Your Opinion is as follows

quote:

---

Hackers will be prosecuted to the fullest extent of the...

I have a test instance at the house of SQL 7 and 2000. I can put thru the paces after Dec 1st.

Can't say there site is too well put together...