Viewing 15 posts - 35,761 through 35,775 (of 39,804 total)
Honestly, I haven't found a good way to do this. I suspect some type of UML tool like rational would work well, but they are so expensive and you have...
November 11, 2003 at 3:11 pm
I'm sure there's a way, but offhand I can't remember what it is.
this might help a little:http://www.sqlfe.com/default.asp (haven't used it)
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 3:09 pm
the only way you could check across all servers would be if you have linked servers connecting them.
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 3:02 pm
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
Viewing 15 posts - 35,761 through 35,775 (of 39,804 total)