Viewing 15 posts - 8,221 through 8,235 (of 9,244 total)
have you tried running it from the DVD?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2009 at 2:55 am
where are you running the setup from CD, HDD, etc?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2009 at 2:09 pm
Adam Bean (4/30/2009)
SELECT
[name]AS [DBName]
,SUSER_SNAME([sid])AS [DBOwner]
FROM [master].[dbo].[sysdatabases]
ORDER BY 1
this should do it
select [name] as [DB Name], SUSER_SNAME([owner_sid]) AS [DBOwner] from sys.databases
order by 1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2009 at 1:30 pm
Hi
passive nodes first, check this link for further details
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2009 at 1:14 pm
rgillings (4/16/2009)
Truncate also will RESEED a table.
that is correct
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2009 at 1:54 pm
the 2 biggest differences between std and ent are online index rebuilding and partitioning. Also AFAIK page level restores are only available in sql2005 ent
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2009 at 7:14 am
also, if i remember correctly truncate will reset any seed\incremental value on ID columns,etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2009 at 6:57 am
yes, i thought of that but running it through SSMS the query takes a short while and thats just on my laptop. Imagine on a server with 4 or more...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 4:47 pm
RBarryYoung (4/13/2009)
I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 10:10 am
this should cut down on the amount of procedures returned
select 'exec sp_helptext ' + name from sys.objects where type = 'P'
and is_ms_shipped <> 1
order by name
you dont want...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 6:35 am
presumably you are using sql2005 standard x64?
you may want to set the min memory to something sensible!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 6:19 am
hmm ok, the enumavailablemedia is pretty straight forward but i cant find any usage info for enumdirectories. Currently my treeview is populated with 2 logical drives and some folder entires...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 6:16 am
set up a simple server side trace and leave it running for a day or so. Should be able to find out/what is changing the status!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2009 at 2:24 pm
has the TCP/IP port number been changed under TCP/IP settings?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2009 at 5:38 am
dobrien (3/11/2008)
-c(still don't know what this is for)
David, this parameter stops the service being updated (i.e. running/stopped/etc) in the services.msc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2009 at 5:36 am
Viewing 15 posts - 8,221 through 8,235 (of 9,244 total)