Viewing 15 posts - 8,926 through 8,940 (of 9,241 total)
xp_regread to enumerate the installed instances in the registry 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2008 at 6:55 am
Mohanraj (9/2/2008)
Created Supervisor group in the Active Directory and added 4 person in that group. (AA,BB,CC,DD) - Windows Authentication users
Later, I have Added AD group Supervisor under Server->Security->Logins
This Supervisor...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2008 at 6:43 am
nlion84DBA (10/24/2007)
Is it also true that you must be running SQL Server 2005 EE in order to take advantage of the space available by using PAE? Standard Edition cannot...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2008 at 3:52 am
indeed the whole table is there for backward compatibility, the SQL2005 table is sys.objects
You will also find some other sys------- tables which are for backward compatibility too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2008 at 10:09 am
egpotus (9/1/2008)
EXEC @hr = sp_OAMethod @object,'Connect',NULL,N'MYLINKEDSRV'; print '4';IF NOT @hr = 0 EXEC sp_OAGetErrorInfo @object
if not using windows authentication then you would need to specify the following
EXEC @hr...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2008 at 10:05 am
Lowell (8/29/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2008 at 6:42 am
Vegard Hagen (9/1/2008)
Fearless and clueless is a very dangerous combination.
ohh so true!
Vegard Hagen (9/1/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2008 at 6:33 am
DMC
we dont use maint plans (they generally are a pain). All our maint\backup jobs are scripted using T-SQL.
Any database maintenance ops should be carried out before a backup. As Gsquared...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2008 at 9:42 am
first thing is to ascertain if anything was inside the missing file.
start by querying the sys.sysindexes table and sort by filegroup id. Get the file group id of the missing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2008 at 6:20 am
i too have seen this before.
SQL server loves RAM, give it the amount you think it will need. if it requires more then add extra sticks
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2008 at 2:52 am
zombi (8/28/2008)
So how can i add user into that group?Thank you very much for your time. Waiting for your reply.
Cheers
Zombi.
via active directory!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2008 at 2:36 am
in an ideal world 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:33 pm
the following will forcefully shrink the logfile, set recovery model to FULL first
--Forcefully Reducing the Size of the SQL Server Log File
--(These instructions are rooted in SQL Server 7, but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:28 pm
Waseem Jaleel (8/28/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:18 pm
yes, that is correct. The first 70% of the log is unused, the active portion (status of 2) would prevent the log from shrinking to a realistic size. What is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 2:58 pm
Viewing 15 posts - 8,926 through 8,940 (of 9,241 total)