Viewing 15 posts - 1,741 through 1,755 (of 1,790 total)
It looks the the restore of a file to a newer version of SQL Server. Is this a 7.0 file being restored to SQL Server 2000?
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 9, 2001 at 3:29 pm
Sounds like a job for updlock.....(note the super hero undertones - mighty dog generation anyone....)
From BOL...
UPDLOCK Use update locks instead of shared locks while reading a table, and hold locks...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 5, 2001 at 2:05 pm
This is a link to an MS msi clean utility that may help. It doesn't list the MSDE product as one of the covered installs but, I believe that is...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 4, 2001 at 11:24 am
Try this in a SQL Job;
xp_cmdshell '\\yourserver\drive:\path\test.bat'
You may even want to build in (either in your .bat file or in SQL) a little rename script so that you can keep...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2001 at 7:35 am
I part time in many things but 75% of time is MS DB servers (5 SQL 2K, 10 SQL 7.0 and 2 SQL 6.5) that host a myriad of applications...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 2, 2001 at 3:34 pm
Neil or anyone,
Can you tell me more about "Note: The problem is not the same as the problem with multiple emails in an operator causing SQL agent to stop"?
I have...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 27, 2001 at 11:10 am
Well it definitely sounds as if the .mdf has problems but it is certainly odd that it did not report similarly when attaching to the server. Hmmm. Anyone else?
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 25, 2001 at 11:02 am
Did you have multiple log files?
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 25, 2001 at 10:51 am
My bad, I assumed that the database already existed and that the files were detached. So, being that you are going to create a "new" database with just an .mdf...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 25, 2001 at 9:20 am
Use the single file attach stored proc and you should be good to go!
EXEC sp_attach_single_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 25, 2001 at 8:33 am
Andy - Good laugh!!!
However, I am sure that this fine gentlemen is looking for undocumented stored procedures which there are several articles on this site to cover most of...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 24, 2001 at 10:46 am
Dan,
Here are a couple of MS Sites to get you started. The Books On Line is a download that is a great tool and place to gain knowledge of the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 20, 2001 at 8:50 am
My guess is that this is a shared Access Database which then requires all ODBC DSN Names to be the same as well as connection properties for the linked tables....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2001 at 2:54 pm
Check out this article http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp
I have found this to answer most of these problems.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2001 at 6:55 am
Did you try the copy database wizard that Andy recommended.
Expand the server in Enterprise Manager, right click on the Databases folder, select All Tasks, Copy Database Wizard.
This will...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 14, 2001 at 3:13 pm
Viewing 15 posts - 1,741 through 1,755 (of 1,790 total)