Viewing 15 posts - 421 through 435 (of 461 total)
I would definitly vote for Profiler (or SQLTrace) where you only have to select the "Audit Login" and/or "Audit Logout" event classes.
You can save the result the a file or...
February 24, 2003 at 2:33 am
Doeas anybody know if Litespeed is able to work together with other backup softrwares, like TSM (Tivoli Storage Manager)?
Actually we have a mainframe based TSM server with a mainframe attached...
February 24, 2003 at 2:26 am
We have had nearly the same issue with Compaq MA8000 and Proliant servers running W2k and SQL2k Ent.
It came out that the W2k SP3 was buggy if your environment had...
February 24, 2003 at 2:17 am
Some comments:
For Chance:
First of all this is a technical site (I like very much) and not a linguistical one. The really aim of that is to spread all the infos...
February 6, 2003 at 7:14 am
An another option is, but this is more tricky, is to separate your table to backup on separate filegroups (and therefore separate files).
So you can backup and restore your database...
January 31, 2003 at 9:41 am
I would say it depends on your configuration.
Having 40% freespace left in your log could be few as it coud be far enough.
40% of 18 GB is much less then...
January 24, 2003 at 12:06 pm
But Antares, by rebuilding the indexes actually you are rebuilding the stats as well. So the update stat should not really necessairly take place within your maintenance job.
This is what...
January 21, 2003 at 4:04 pm
Here is an example from BOL:
Open SQL Query Analyzer, connect to an instance of SQL Server, and run the Createtb.sql query.
Open a Command Prompt window and change the current directory...
January 18, 2003 at 7:47 am
But don't forget!
xp_cmdshell is running on your server and not on your workstation. So if your BAT file are located on your WS your TSQL wont work unless youwill decribe...
January 18, 2003 at 7:38 am
The wonderword is sp_who. or better master..sysprocesses.
There you can see the hostname what you can ping to get the IP address. Within whe sysprocesses you can also have the net_address...
January 16, 2003 at 9:31 am
Normally there is no limit of the numer of times a file file grow.
This error message means that you either run out of available disk space our you have reached...
January 15, 2003 at 9:53 am
You can do that at the server level. In this case it will be valid for everybody by using EM there right click your server->Proprieties->Server Settings->Default language for user.
You have...
January 15, 2003 at 9:40 am
My opinion is (that may be wrong) that for the log you should not necessairly have RAID 1+0 because the log is mainly write only.
Which is not the case for...
January 15, 2003 at 1:50 am
As I read you, Lee, I have to recognise that my life as DBA is not so terrible as yours.
Therefore I am looking to the sun and smiling for ever...
January 14, 2003 at 10:01 am
It is just impossible to generate the schema script using EM.
I suppose that MS didn't think about managing as many tables. SQLServer is able to manage a lot of data...
January 14, 2003 at 3:33 am
Viewing 15 posts - 421 through 435 (of 461 total)