Viewing 15 posts - 1,966 through 1,980 (of 2,897 total)
I was just suggesting you output the results into a text window instead of a grid, then you can more easily search:
"Query" -> "Results To" -> "Results to...
February 24, 2009 at 10:35 am
There are also non-SQL product that use .MDF file extensions. Do you have some other product installed ?
February 24, 2009 at 10:18 am
Maybe you already did something like this but as the earlier post suggested, run:
exec sp_MSforeachdb 'Select ''?'' as DB_Name, * from ?.dbo.Sysfiles'
output to text, not grid, then search for the...
February 24, 2009 at 10:08 am
Mike Levan (2/17/2009)
February 24, 2009 at 9:48 am
(I'm having SP1 installed on the server)
FYI, SP3 was released recently.
February 23, 2009 at 8:22 am
solution_developer (2/20/2009)
pls help am running out of space and need to either reschedule it or disable the...
February 23, 2009 at 8:14 am
You could use Idera's SQL backup tool with object level recovery. Then you can backup the database, and restore just the selected tables. IIRC, it will restore just the data,...
February 23, 2009 at 8:10 am
If you are not that familiar with SQL, you can use the GUI to schedule a restore. Go into Management Studio, use the GUI screens as if you're doing a...
February 23, 2009 at 8:03 am
In some cases I already restored the databases, so how do I handle the orphan SID problem ? I can re-restore most of them if that helps, but 1...
February 21, 2009 at 10:28 am
Neither #1 or #2
I updated my instructions. Use SQL 2005 for the export step, not SQL 2000.
February 18, 2009 at 4:41 pm
To Export:
Map a drive to a location to save your exported DTS packages: eg. server\DTS_Exports
Use SQL 2005 Management Studio
Copy DTS name into your clipboard.
Right click the DTS “Export”
Highlight the DTS...
February 18, 2009 at 4:02 pm
Do you want to convert them to SSIS, or keep tham as legacy DTS packages like we're doing ?
February 18, 2009 at 2:30 pm
Wow ... all kinds of solutions in this thread !! .... now if I can figure out which is "best"
February 18, 2009 at 9:36 am
You can use the GUI to run a backup or restore, but instead of clicking the final "OK", choose "Script to new window". This will generate the code that SQL...
February 16, 2009 at 2:41 pm
You can have a separate job for monthly that puts the backup in a separate folder so it won't get overwritten.
February 16, 2009 at 12:23 pm
Viewing 15 posts - 1,966 through 1,980 (of 2,897 total)