Viewing 15 posts - 35,911 through 35,925 (of 39,804 total)
Shouldn't be any different. If you query syslogins, do you both seem the same rows?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 22, 2003 at 3:02 pm
Lumigent is really your only option, but if you only need to "read" the log, then there is a lower priced version I beleive.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
September 22, 2003 at 3:01 pm
Yikes, I'd check the BOL for 6.5. I suspect this is in the terabyte range though. I thought I had a 100GB db sometime ago. I know I had a...
September 22, 2003 at 2:57 pm
Good idea. Search is one of our week points , but I'll pass along the note to the others. Maybe someone will find a little time.
![]()
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
September 22, 2003 at 2:55 pm
Thanks for the replys. I'll add them to my list.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 22, 2003 at 2:18 pm
There was an ADO bug that truncated text columns if they were not the last columns in the result set. I don't think that's the case here though.
One other ?,...
September 19, 2003 at 2:39 pm
might need to "reseed" the desitnation table when you are done as well.
dbcc checkident
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 19, 2003 at 2:36 pm
We have a general IDS (From NA) that monitors all servers, but not specifically for SQL Server.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 19, 2003 at 2:34 pm
Not that I know of. I wish there was as a default.
What I've done in the past is search for new objects each day and get them corrected ASAP.
Steve...
September 19, 2003 at 2:32 pm
Just tried it here using one SQL 7 server to profile another. You need to be sure when you create the trace that you change the server name on the...
September 19, 2003 at 2:31 pm
We've got Compaq / HP SANs running here with both Compaq and IBM servers connected to them. Some with local storage some without.
In the last 9 months, we've had lots...
September 19, 2003 at 2:27 pm
Thanks for the note. Glad you like it.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 18, 2003 at 11:43 am
Use the varbinary or image type.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 18, 2003 at 11:43 am
If you change auth from NT to SQL, you need to change this on the server as well.
This should work easily enough if you do that. NT auth shouldn't work.
Steve...
September 18, 2003 at 10:20 am
http://www.microsoft.com/traincert/mcp/mcdba/default.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 18, 2003 at 10:19 am
Viewing 15 posts - 35,911 through 35,925 (of 39,804 total)