Viewing 15 posts - 166 through 180 (of 388 total)
The pain at my site is more profound, Google desktop search is blocked because you have the option to cach on Google's servers. I have to use MS desktop search...
August 22, 2007 at 4:04 pm
Is there a pressing business need to upgrade to 2005, if not it might be best to wait until Febuary 2008 for the release of SQL 2008.
July 27, 2007 at 2:51 pm
Redgates SQL compare is good, you have to pay for it but it makes this really simple.
July 27, 2007 at 2:13 pm
Thats how I have set these up in the past as well, but when you do the standard install the data and log files are always in the same folder,...
July 20, 2007 at 8:40 am
Check if you have a mssqlsystemresource.ldf file in you .mdf folder, if so follow the steps I laid out to get the services up and then reaply the SP2 patch...
July 19, 2007 at 2:28 pm
If it turns out you have an issue with the mssqlsystemresource files then I may have come accroos this myself.
After much digging it appears there is a bug in service...
July 19, 2007 at 2:21 pm
Have you looked in the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log file, which system databases did you move, was one of them the mssqlsystemresource database?
July 19, 2007 at 2:15 pm
which version of SQL client tools are using to parse\run the scrips, what service pack are they on?
July 16, 2007 at 2:56 pm
If you have down time I would test restarting SQL or rebooting and see if this does set this, if not you are set, if it does you know to...
July 16, 2007 at 2:51 pm
Not unless someone has setup a startup script or group policy is setting it, I wouldn't be suprised if someone just changed it by mistake.
July 16, 2007 at 2:25 pm
have you checked that windows and sql logins are enabled on the security tab of the SQL servers properties?
July 16, 2007 at 1:59 pm
How many databases or users are there on this instance, I have noticed that on a few of our boxes that have many databases or users that management studio hangs....
July 16, 2007 at 11:54 am
Ronzo,
Thanks for the post, I changed a user who owned objects to sysadmin to carry out a test and did not change it back, and came accross this issue, just saved...
April 23, 2007 at 2:36 pm
Michael,
My mistake, meant to say OPENROWSET:
select whatever from
OPENROWSET
('SQLoledb',
'server=YourServerName;uid=YourUser;pwd=YourPassword'
,
'select whatever...
April 14, 2007 at 2:40 pm
Check out OPENQUERY in books on line, this way you can make the connection on the fly.
Andrew
April 13, 2007 at 4:20 pm
Viewing 15 posts - 166 through 180 (of 388 total)