Add the Alter Database commands to your string in the variable, and then execute the string.

declare @Cmd varchar(8000);

select @Cmd = 'alter database MyDB add file ...' -- put the rest...

Do you want different columns, or do you want a comma-delimited list?

You can do a dynamic pivot through dynamic SQL of various sorts. Simple-Talk (www.simple-talk.com) has a good article...

Redundancy is the only answer to this kind of thing that makes any kind of sense to me.

Avoiding "the cloud" because it's "less secure" assumes that your local servers/computers are...

I'm assuming you've looked at what Windows says is using the memory, in Task Manager. Right?

What besides the OS and SQL Server is running on that server? What's...

I wouldn't mess with the log shipping, not if it's for DR purposes.

Back up, compress, ship over, and so on.

I could be wrong, but I don't think it'll let you set up the same computer as all three. Mainly, why have a witness on the same as the...

Is it being blocked by other processes in the table?

Are you trying to dynamically move the files?

Why assume the files are in a default location, when you can query sys.database_files to get the exact data?

I'd start with just plain searching online for tools and articles. I plugged "migrate oracle to sql server" into Bing (use whatever search engine you like). The second...

It is definitely possible. Sometimes it's even the best column for that.

It'll depend on how you're using it. What does the column mean in the data?

It sounds like you're working on preventing SQL injection in dynamic SQL. Is that correct?

If so, have you looked into using sp_executesql for parameterized queries instead of executing a...

On the cursor definition, you can change that from a Left Outer join to an Inner Join. The Where clause forces that anyway.

Glad I could help out.

Grant Fritchey (1/12/2011)

---

WayneS (1/12/2011)

---

Grant Fritchey (1/12/2011)

---

Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are stored and...

Take a look at xp_readerrorlog and see if that will do what you need.

michael sorens (1/10/2011)

---

Long ago I heard a similar comment that newspaper articles are aimed at an eighth grade level. On any given day I can usually find a newspaper clipping...