GilaMonster (8/14/2009)

---

Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

Shrinking causes massive fragmentation and will just result in...

It's important to note that if you CANT, for some reason; need to resolve with FQDN, etc then you can work around this with an LMHosts or Hosts entry.

We have...

Bump

That only works if there's a person, sitting there, watching the replication monitor, 24x7.

I need it to retry after 1 second , so that I can get the status of...

I was afraid of that.

Oh, well. I guess we fall back on our old friend sp_executesql.

Unfortunately, your example results in the exact error I'm referring to. You still get the same issue.

That was just some example code. In the real environment, only a chunk...

I've had similar situations and I agree with your solution of using views, then referencing them in your sp's

However, I'd strongly recommend against granting your users in one DB the...

I was trying to avoid doing that, but it IS a solution

BTT

First off, thanks for the reply!

I've read thru that.

If I understand it correctly, I should be able to create a proc that references at table on a linked server that...

Anyone?

http://FTP.exe can take a script file as an argument.

Put your commands in this file.

Creat a scheduled job of type CmdExe that calls http://ftp.exe -s:MyScriptfile

 

 

FTP [-v] [-d] [-i]...

I found a similar problem quite recently.

In my case, it was the total number of characters in the field names.

A couple of "as fld1" statements in my query and the...

OK, I thought I was going overboard with a 3 server system in a rack shoved into a closet.

You have the $20,000 version of SQL Server just lying around for...