Viewing 15 posts - 466 through 480 (of 597 total)
I post answers if I think I can help someone or contribute to a discussion. I have asked questions if I thought someone could help me. Points aren't a factor. ...
March 4, 2004 at 9:30 am
You will get a violation only if SQL Server is up. If SQL Server is not running you can copy/move anything you want. Of course if you move (as opposed to...
March 3, 2004 at 11:14 am
See BOL on startup options. I believe you need the -d, -e and the -l options showing where is the master, error and log files. If you leave them out...
March 3, 2004 at 10:50 am
I don't think you can prevent access to master. Everyone has access to master, whether its the default db or not via the guest account - which can't be dropped.
March 3, 2004 at 10:41 am
This may be just terminology but if you stop SQL Server and move the files (As opposed to copying them) what happens when you start up SQL Server and the...
March 3, 2004 at 10:23 am
I assume you have tried attaching with sa as well and are unable. You may need to rebuild master. (Rebuildm.exe) SEE BOL also before attempting this:
If a current backup of master...
March 3, 2004 at 10:18 am
I've had this problem before as well. Try putting the following before the generated job scripts to see if this fixes things:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
March 3, 2004 at 9:58 am
I didn't refresh my screen so I didnt see your post noeld.
March 3, 2004 at 9:11 am
In EM right click on the Jobs tab and select All Tasks, Generate SQL Script. Generate the script and execute in in the msdn database for your new server.
March 3, 2004 at 9:08 am
What about other stuff - tables stored procs etc. Are you not bring this over as well?
One method is just to create a script from the job(s) and execute that...
March 3, 2004 at 8:45 am
David Hardin wrote a great script to convert an array into a table which can then be joined to your other tables. I use the script often. see
http://www.sqlservercentral.com/scripts/contributions/100.asp
March 2, 2004 at 1:49 pm
Check the Event log (and possible SQL Sever log) for errors. The Application file in the event log should provide more clues as to why this won't start.
March 2, 2004 at 10:51 am
The default database for sa should be set to master which should (hopefully) always be there. It would be cool if a user could change their default database but then...
March 2, 2004 at 10:44 am
I use the following when creating a test version of a database based on the most recent back up.
declare @physical_device_name nvarchar(128)
declare @backup_start_date datetime
declare @db varchar(128)
set @db = 'dbname' ...
March 2, 2004 at 10:29 am
If this is a .NET application is the connection object being closed and set to NOTHING? If so you'll just have to wait the 2-3 minutes for the connection to...
March 2, 2004 at 10:07 am
Viewing 15 posts - 466 through 480 (of 597 total)