I got bcp working!

Here's how:

1. Open SQL Server Configuration Manager and go to the Named Pipe Properties of your instance.

2. Change the value to:

Note: if your 2000 instance, the old...

Have you ever used sp_MSForeachDB? It is an undocumented procedure otherwise I would provide a link to BOL for you.

What you want to do is call sp_MSForeachDB and provide an...

Welcome to the site Christi! Please post back to this thread once your blog is up and running. Lots of people add their blogs to their signatures around here too...

chumphrey 12211 (8/24/2011)

---

Thanks for the reply. I guess I was wondering if there was a way to "alias" the named instance to avoid making programming changes to the migrated...

With ample hardware you should be fine mirroring 9 DBs. The upper bound has to do with how many worker threads required by each mirroring session (i.e. sessions are per...

Yes. I would...

chumphrey 12211 (8/22/2011)

---

I am upgrading and migrating from SQL Server 2000 to 2008 on a new server. I created a new named instance on the new server. I...

gmamata7 (8/21/2011)

---

Thank you,

I went through the link http://www.sqlskills.com/blogs/paul/category/CHECKDB-From-Every-Angle.aspx

and it says DBCC CHECKDB won't cause blocking.

But, In my case blocking happening only when DBCC CHECKDB runs.

So how can we rule out...

I have always written scripts to pull reports from the databases directly to show what was in place. You can find lots of examples online (this site has a bunch...

arpitsinghal.tcs (8/24/2011)

---

Hi All,

I want to import data from flat file into SQL Server table using SQL CLR ..

Also, we need to do some manipulation /formating of the datetime column

Size of...

julia.streatfield (8/24/2011)

---

My boss wanted to know if we could use Policy Management to literally create maintenance plans and then distribute them around the organisation. I think he has now...

sleipner (8/22/2011)

---

I have an Access application that connects via recordsets and SQL Server authentication using an internal account & login, which is shared by all the users. However, I...

If it is only for tables and SPs then you can use this:

EXEC sys.sp_helprotect

@username = 'role_name' ;

If you need to whole picture you'll have to...

I have not seen that one either. Google yielded this thread...related?

http://www.sqlservercentral.com/Forums/Topic1125956-357-1.aspx

What is your ActiveX script doing? Evaluate whether you're running into an issue because the DTS pkg is trying to load a 32-bit binary into a 64-bit process.