Viewing 15 posts - 35,686 through 35,700 (of 39,720 total)
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
Every connection has read/write according to permissions. It is not based on the connection, but the login.
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
You can dig through the dbcc commands and see what's in the procedure cache, but not the database cache.
Perf mon will only give you total server memory.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
November 6, 2003 at 9:28 am
You're welcome and glad it's working.
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:25 am
Viewing 15 posts - 35,686 through 35,700 (of 39,720 total)