Viewing 15 posts - 36,706 through 36,720 (of 39,771 total)
Not through SQL replication. DTS has a login transfer task that you could use.
There is also a createdate in syslogins that you could use to build something.
Steve Jones
December 27, 2002 at 9:47 am
Server might crash if you lose the array. If you're good with that, then no issues.
Steve Jones
December 27, 2002 at 9:45 am
I think there is an event that fires on login and you might be able to get something to work.
Instead, I'd write a job that scans sysprocesses every minute and...
December 26, 2002 at 9:25 am
I'd also bcp or DTS out the entire table to a text file to be sure you have it.
Then do a backup.
Then try rebuilding the clustered index (or creating one)....
December 25, 2002 at 4:24 pm
Happy holidays and I'd vote for Andy's solution. Much simpler to do.
Steve Jones
December 25, 2002 at 4:22 pm
Might want to also run Profiler and see what's hitting tempdb so hard.
Steve Jones
December 25, 2002 at 4:20 pm
What should happen:
User contacts SQL Server, sends credentials, SQL then verifies these with the DC and once verified, checks syslogins (and sysusers) for access before responding to the client.
Steve Jones
December 24, 2002 at 11:28 am
Sorry, not a cluster guy. Try to get Brian to look at this.
Steve Jones
December 24, 2002 at 10:07 am
Don't try to reinvent this. You will forget something and screw yourself.
Use VSS or CVS or some system designed to do this. Maintian strict controls on this.
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
Steve Jones
December 24, 2002 at 10:05 am
Get Brian Kelley's book for some ideas:
http://www.netimpress.com/shop/product.asp?product_id=NI-SQL2
Don't see too much on benchmarking per se. Probably should write something up on this.
Also:
http://www.sql-server-performance.com has lots of articles on perfromance tuning.
http://www.sqlservercentral.com/columnists/nboyle/memorytuning.asp
Steve Jones
December 24, 2002 at 10:02 am
There is a new security book from CurlingStone, SQL Server Security Distilled, that covers this in great detail. If it's taking significantly longer, you have network issues.
As Anatares said, once...
December 24, 2002 at 9:45 am
Most likely what you want to do is change your PK index to non clustered. High selectivity, etc. Not worth having the clustered. I'd move the clustered to the StartTime...
December 24, 2002 at 9:42 am
December 24, 2002 at 9:32 am
Thanks for the update.
So the issue was lack of disk space? On the paging file?
Seems like a memory issue, like you don't have enough memory available at that time for...
December 23, 2002 at 11:10 am
Never setup an operator as a person.
Setup a distribution list in Exchange and use that as the list in SQL. Prevents points of maint if the dba changes. The network...
December 23, 2002 at 11:08 am
Viewing 15 posts - 36,706 through 36,720 (of 39,771 total)