Viewing 15 posts - 35,866 through 35,880 (of 39,903 total)
There are a number of products to do this. FMS Software makes one.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 10:26 pm
The clustered index is the data. So if you move it, then the data moves. The PK may or may not be the clustered index. They are not related, though...
November 6, 2003 at 10:06 pm
Chris is right. You cannot restore with people in the db. You could implement 2 phase commit as well, but that would be a pain and a lot of work.
Steve...
November 6, 2003 at 10:05 pm
The DTS package still holds a handle to that file. I've seen similar issues. I'd setup a 2nd job step to do the email so the package closes.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best...
November 6, 2003 at 4:11 pm
Instance name same as server shouldn't be an issue, but you never know.
As far as the lack of servername, it might work from the local server, but I'd be wary...
November 6, 2003 at 4:10 pm
What connection string are you using?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 2:41 pm
The app needs to support server\instance connections. Not all do.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 1:40 pm
Did you try "server\instance"?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 1:38 pm
use a trigger to return "select count(*) from inserted" and then return that from the SP.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 9:53 am
Interesting comments. I follow the debate and ran Linux at .7 myself. It's nice, but it's a tool to me and for years, I haven't had the need for the...
November 6, 2003 at 9:51 am
Can't really try it and not sure of the issue, but the reality is that example code from MSDN is notoriously buggy and incomplete. I wouldn't be surprised if there...
November 6, 2003 at 9:42 am
Extraquest (www.extraquest.com) is down the street from me in CO and they do Oracle and SQL. Most I think are for Oracle. There's also http://www.remotedbaexperts.com/.
NOTE: I haven't talked or...
November 6, 2003 at 9:35 am
Backing up across the network isn't supported because SQL doesn't have tolerance for slow writes. A file copy will wait and retry, but since SQL is writing quickly, if there...
November 6, 2003 at 9:33 am
See if they can run sp_addlogin (not with EM). This will tell you if they have server level access.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 9:31 am
There is some limited information in BOL, but I'm not sure what I can post yet.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 9:29 am
Viewing 15 posts - 35,866 through 35,880 (of 39,903 total)