Any chance you are not in the fixed sysadmin server role?

Just outta curiosity... How long does it take to go 1 iteration through your cursor? It may only take 3 seconds for 1 time, but if you have...

does anyone else in your organization have the ability to open the SAC utility?

what type of access do you have to the server?

can you see the services and tell which...

If you just want the number of open projects for a specific clientID why not use somethign like the follwoing.

SELECT Count(*), ClientID

FROM ProjectStatusHistory

WHERE ClientID = @ClientID

...

Please do not cross post.

This has already been posted here...

http://www.sqlservercentral.com/Forums/Topic581994-24-1.aspx

The easiest way would probably be to use SSIS. You can check the Books online information for some Simple how to's with SSIS. Alternately, you could use BCP.

You...

yulichka (10/7/2008)

---

We don't have off hours. Our server for the web and we have to operate all the time. So, I am trying to see my options. What else can...

make sure you're in the appropriate database context.

Have a look at this and see if it doesn't help you.

Google is your friend...

http://social.msdn.microsoft.com/Forums/en-US/vbinterop/thread/a8930f04-9f7e-4023-ae25-57a16ec23d9e/

You could import them into a temporary table in your database server and then depending on how you decide, if you want to see duplicates or ones without duplicates, you...

The easy answer is It Depends. Read the Books online sections on each of these. That will help give you a good understanding of what each one does....

This is a cross post from this question http://www.sqlservercentral.com/Forums/Topic581916-65-1.aspx.

Please do not post the same question in multiple forums.

Multi select is a whole different animal all together. For that you'd probably need to pass the values into a stored procedure, parse them out and put it together...

Check out http://support.microsoft.com/kb/249873. It deals with Vista, but the error message is the same. Basically that the dll doesn't exist...

Dllname was loaded, but the DllRegisterServer or DllUnregisterServer entry point...

homebrew01 (10/7/2008)

---

I completely agree with splitting prod from dev/test. We're building out a new data center soon, and probably going to use VM for the servers. The 2 prod...