<snip>

For example you could have it watching a directory and so it will pick up the file as soon as it is entered into the directory, thereby producing the data...

Hey, I don't use bcp, but I found this link for you:

http://www.simple-talk.com/sql/database-administration/working-with-the-bcp-command-line-utility/[/url] and maybe it will help:

-n (native format): The bcp utility retains the database native data types when bulk...

Great article, thanks!

I keep a folder on the server called "Disaster Management". It contains everything I need in an emergency to keep my head 🙂 : scripts...

GilaMonster (6/22/2010)

---

yessen (6/22/2010)

---

But everytime SQL Server needs to be restarted it goes into the same "recovery mode". I want to prevent this from happening and I can't because I have...

I'm surprised no one has mentioned the one drawback of storing packages in the database: you cannot edit them there. You have to export the package to the file...

Perhaps I'm missing something, but if you truly mean "table" when you say table - that is, a table in the database, outside of SSIS - then you cannot and...

Well, I've got an answer from outside SQL Server Central, so I'm posting it back here:

The FK constraints that cannot be made trusted using an ALTER TABLE statement were created...

Kelvin, you didn't say if you were using AD or some other version of LDAP. I have had very little progress trying to query a linked server to a...

To add to Steve's good words:

Forget trying to read the log. You need to understand (1) why it's needed (2) how it works and (3) how to use it.

1....

Thom, I am not sure I understand why that is a bad thing to do.

Everyone, I could use some help with the following questions:

Why is it bad to shrink the...

Lowell (6/14/2010)

---

ok rich; I'm putting a link to CLR Database Project and it's solution; after unzipping it and opening it in the BIDS version of VS2008, if you go to...

Lowell (6/14/2010)

---

that doesn't sound right...if you can do File>>New Project, is there a template for Database Project?

I know you can download the VS Database Template from MS, and there is...

Paul, thanks to a firmly worded and clearly written article of yours I'd read a while ago http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-the-log-and-log-backups-how-to-convince-yourself.aspx, I got this one right.

I agree with the comment someone posted on...

Kim, I don't know if this is any use to you, but I just found the same thing happening to me. I was able to reproduce the problem whenever...

Nope: Ran this on my 32-bit box and got:

8650

3.34139

Specs:

CPU: Xeon E5450 @ 3 GHz

OS: 2003 Server, Standard Ed., R2, SP2

SQL: Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) ...