Viewing 15 posts - 16 through 30 (of 366 total)
Question Answered - The base cd's for the x64 os already has sp1 applied.
February 21, 2006 at 1:34 pm
You can restore a sql 2000 (or 7) database straight onto a sql 2005 server.
Watch the compatibility mode as I seem to remember it stays at the old level. Hence if you want...
February 21, 2006 at 1:30 pm
I was just checking the config for the x64 sql server 2005 server install , and see that is say you need windows 2003 sp1. I can't find any reference to...
February 1, 2006 at 5:33 am
Check the sql server log file to see if the sql server service could take the port. Sometimes other applications take the port before sql, and this is reported in...
July 4, 2005 at 7:14 am
What edition of sql server are you using? If MSDE the network libraries are disabled as part of the install.
Was it installed with tcp-ip?
You can check the sql server...
July 4, 2005 at 6:55 am
No, as the account which runs the sql server service needs access to the sql server.
May 26, 2005 at 5:33 am
I have it on one (new) prod msde install, and a couple of dev boxes.
Waiting for the AWE and SQLDiag fix prior to upgrading older servers, as I try and...
May 26, 2005 at 1:49 am
Have you got the -m startup switch set on the sql server in question?
(Right click on the server name in EM and choose properties. Then startup parameters)
May 18, 2005 at 6:29 am
Public access gives the user what ever permissions are assigned to the public role.
You can have one database owner, but many people in the dbo group.
dbo's have full access to...
May 18, 2005 at 6:25 am
I was thinking of the version info going, with the reg keys above.
To get rid of the null I usually use the following, code
exec sp_dropserver '<oldname>'
exec sp_addserver '<newname>',...
May 18, 2005 at 3:25 am
The only time I have seen this is when certain registry keys have been deleted. ie the \CurrentVersion and \Parameters ones
from
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\
May 18, 2005 at 2:17 am
I'd suggest rewriting the reqery using ANSI-92 e.g.
SELECT count(*)
FROM SAM_GUIA_EVENTOS E
INNER JOIN SAM_GUIA G
ON E.GUIA = G.HANDLE and G.PEG= 752074
WHERE E.CLASSEGERENCIALPAGTO is NULL
May 17, 2005 at 9:15 am
Collation can be set at field level on the table.
May 17, 2005 at 3:55 am
Viewing 15 posts - 16 through 30 (of 366 total)