Viewing 15 posts - 42,451 through 42,465 (of 49,571 total)
One thing to note is that no transactions are actually rolled back. What checkDB is doing is creating a hidden database snapshot to do the check on and the transactions...
December 10, 2008 at 12:37 pm
Chris Morris (12/10/2008)
GilaMonster (12/10/2008)
I do have a couple of fairly...
December 10, 2008 at 8:52 am
Maybe wrap the datediff in a case, when 0 then 1 else datediff...
December 10, 2008 at 8:06 am
I don't have any photos of what Steve's taking about. I was too busy getting pounded into the mat by Kalen.
I do have a couple of fairly good photos from...
December 10, 2008 at 7:56 am
swathi (12/10/2008)
Gail Shaw,Server has total of 3.12 GB memory and from which sqlservr.exe is taking 1.7gb which is the maximum among all the processes that r running at that time.
Nothing...
December 10, 2008 at 7:51 am
In that case, set the database to restricted users before starting the backup. That means that only members of db_owner, db_creator and sysadmin may access the DB.
If that's not...
December 10, 2008 at 7:46 am
Snapshots?
It was existing transactional replication that I set up a couple months back to test some stuff and never dropped.
December 10, 2008 at 7:41 am
Schadenfreude-Mei (12/10/2008)
Insert into a table. Litteraly opening a table, adding a row and whatching the log reader.
I don't know why that's not working. I did exactly that (except I...
December 10, 2008 at 7:28 am
Why do you need to prevent users accessing the DB to do a backup?
December 10, 2008 at 7:26 am
What do you want to see in the following cases?
StartDate: 2008/01/01 07:00:00, EndDate 2008/01/02 18:00:00
StartDate: 2008/01/01 07:00:00, EndDate 2008/01/02 07:00:00
December 10, 2008 at 7:25 am
swathi (12/10/2008)
At that time if we check in TaskManager, the Sqlservr.exe is taking maximum amount of memory usage.
Nothing unusual there. SQL will take as much memory as it's allowed...
December 10, 2008 at 7:23 am
What info are you looking for?
Try this:
select * from sys.symmetric_keys
December 10, 2008 at 6:31 am
asrisl (12/10/2008)
I don't have that in my list of programs, or in any menu that is on-screen when SQL Server is running.
It's not a SQL menu. Window's administrative tools....
December 10, 2008 at 6:25 am
asrisl (12/10/2008)
December 10, 2008 at 6:07 am
Needs more quotes
CAST(S.xusertype AS INT) = CAST(C.[User_Type_Id] AS INT)
WHERE T.[Name] = ''' + @TableName + ''' AND
T.Schema_Id = 1' --@@@@ (1 = dbo.)
Square brackets denote identifiers, ie table or...
December 10, 2008 at 5:58 am
Viewing 15 posts - 42,451 through 42,465 (of 49,571 total)