Viewing 15 posts - 35,731 through 35,745 (of 39,771 total)
Hey, I saw the Concorde out here at the Museum of Flight in Seattle. Looks pretty cool. Not economical, but everyhting can't be about money. Lots of pride in that...
November 11, 2003 at 3:00 pm
Thanks for the notes and suggestions. Busy with PASS now, but I'll try to test later.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 2:59 pm
How often does this happen? I've setup a separate table, have the user (through some interface) insert a value here and then have a job run every minute/10 minutes/hour/whatever, and...
November 11, 2003 at 2:56 pm
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
Viewing 15 posts - 35,731 through 35,745 (of 39,771 total)