personally, if the answer to my previous is q is yes then i'd do something like:

1) export my server list that i keep in a handy sql table to...

You're trying to disable windows update from a script running in sql?

Why are you invoking a clear screen command in a script that should be pretty quiet and writing to a file?

try piping the output of the .ps1 to a file or something.

If your database needs to be available from more than one machine, and you don't have a server to host it, you might consider an Azure solution instead.

My devs think this is the magical 'sql gofast' hint.

*facepalm*

Would this scenario work?

My SQL Agent jobs for this thread connect to the instances of the databases, not the local versions, so if I had another SQL server...

to disable all non-clustered indexes on table 'x;'

declare @Ind varchar(255)

declare @sql varchar(8000)

DECLARE vend_cursor CURSOR

FOR SELECT Name FROM sys.indexes WHERE...

Ed Wagner (9/23/2015)

---

Alvin Ramard (9/23/2015)

---

Luis Cazares (9/23/2015)

---

Manic Star (9/23/2015)

---

patricklambin (9/23/2015)

---

I don't think so. These functions have been introduced...

Luis Cazares (9/23/2015)

---

Manic Star (9/23/2015)

---

patricklambin (9/23/2015)

---

I don't think so. These functions have been introduced only to make easier...

Grant Fritchey (9/22/2015)

---

If it's only a small chunk of the overall database, you might look into building an Integrations Services (SSIS) package to do the move. Otherwise, for a subset,...

patricklambin (9/23/2015)

---

I don't think so. These functions have been introduced only to make easier the translation Access towards...

kim / data detection group (9/17/2015)

---

Of course, SQL Server could certainly benefit by implementing the Package concept that Oracle provides.

You can bundle all your related procedures and functions into a...

Which i just forwarded to the manager of the dev team. They are planning a code review of the...

My co-dba and I wrote some really bad poetry:

one proc to rule them

one proc to bind them

one proc to bring them all and in the darkness, deadlock them

'precious deadlock' ...