Viewing 15 posts - 8,926 through 8,940 (of 9,244 total)
AFAIK on a server side trace you would need to use the function fn_trace_gettable to read the trace file(s) into a table
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 5:10 am
when you launch the installer (via cd or control panel) you get the option to modify an existsing instance. You select an instance then elect to uninstall components from that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2008 at 5:05 am
denying select and insert should stop the users opening the objects, are you sure they havent been given sysadmin server role?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2008 at 10:32 am
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
Viewing 15 posts - 8,926 through 8,940 (of 9,244 total)