Try running this on the master database of the SQL 2000 server (I did some digging and apparently this is what the sql script was supposed to produce):

create procedure sp_tables_info_rowset_64

...

Good point, I was looking at the wrong window when I typed that. But they are all 2005 articles or lower I think, so they will work. Besides,...

Also I find that SQL Data Compare by Red Gate is a great tool for not only doing the equivalent of those queries but also giving a GUI to see...

Not all of these are for 2008 but the concepts will be similar and transferrable:

http://www.sqlservercentral.com/articles/Performance+Tuning/fileoptimtips/443/

http://www.sqlservercentral.com/articles/Files+and+Filegroups/65538/

http://www.sqlservercentral.com/articles/Administration/64275/

espanolanthony (8/3/2010)

---

I haven't heard about "reindex by filegroup". Please highlight how to do it. and yes i have 1 mdf, 1 ndf and 1 ldf. So how do...

You're eventually going to have to move things into separate filegroups on separate physical disks, and do separate filegroup backups, and reindex by filegroup on different windows. That's really...

The actual error would be in any SSIS package logs that get created, and that path is package-specific. You should look to see if there are any logs being...

Sounds like the execution plan is getting stale, or the way you are sending parameters is not consistent from the app. This probably needs some research or tuning, but...

The only foolproof way I know of (and you probably need a domain admin account for each domain to do this) is to do an LDAP query against AD to...

Or you could use Log Parser to scrape the event log (it's in the Application Log) and put the results into a table. As long as the server itself...

That query isn't reliable for all servers on one domain. Per Books Online:

"-L Lists the locally configured servers and the names of the servers broadcasting on the network."

If...

I had the same concern, so I backed everything up first (and I would still recommend that). Didn't cause a single problem that I ever found on my old...

OK that helps. In 2005 I had almost the exact same thing happen to me, and this KB article solved it:

http://support.microsoft.com/kb/906954

Basically you have to reapply the SP4 procs on...

Can you post the error you are getting? Because it sure looks like the query that works is hitting a different database than the one that doesn't work, and...

Maybe the default DB for the linked server account is not the same as the DB you are using in the four-part name that fails?