shamshudheen (4/11/2008)

---

SQLZ (4/11/2008)

---

EXEC and EXECUTE are identical - one is just shorter than the other. sp_executesql supports parameter substitution and it generates execution plans that SQL Server can more...

Okay - the first thing that went thru my head was this (before my AM coffee. It's Friday...its...

Can you post the T-SQL used to backup the DB? Right now, I don't think we have enough info to pinpoint the answer.

I would start with looking up the following in BOL

SET STATISTICS IO

you could try renaming the table, create a new one, and copy the data back. i dont think I would recommend, but that is an option

I have not created a UDDT, if you post what you have, or similar, we may be able to assist a bit more. I suspect it is just a...

:w00t:

Nice catch! I dont know why I missed that. I guess I grew to tired making my own data and table to finish verfiying the results. 😎

I suspect this will do it - is this homework?

--== Create test table(s)

CREATE TABLE #table1

(

userid VARCHAR(10),

...

Now, what I'm interested in is the following:

- How do I find the drive letter where the log files are stored, similar to the method I used in querying dbo.sysdatabases?

-...

Thank you everyone! I love the responses.

Yeah - If you can ping the virtual SQL server by name, I would think you can connect via name. Other options are to connect via IP. If...

Matt Miller (4/2/2008)

---

I think your colleague is onto something. WMI is designed for this kind of stuff (remotely querying and possibly modifying settings, using WQL). Of course -...

Michael Earl (4/2/2008)

---

Ok, I hate to pick like this, but I have to ask.

Are your servers moving around onto different domains so often that you need an automated process to...

DBA (4/2/2008)

---

hi thanks for the link, i tried doing the article before but some of my servers are in the network but are not part of the domain. how do...

The code I posted above I lifted from this link (an article by David Bird that he got from Rodney Landrum):

http://www.sqlservercentral.com/articles/Integration+Services/61774/

It may take a bit, but you can clean this...