Viewing 15 posts - 796 through 810 (of 907 total)
Yes it might be true you can't build the script, although it is really easy to do it manually, and if I needed to move maintenance plans around it would...
September 19, 2002 at 8:12 am
This is also a kludge, but at least the original table stays intacked and no views.
This example avg's every two royalties together in the pubs.dbo.title table.
use pubs
create table #temp (id...
September 18, 2002 at 4:52 pm
Guess that's one more HACK to add to my list. Thank you for the feedback.
[/quote]
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at...
September 18, 2002 at 3:15 pm
If you want your regular select statement to run against the database from where the SP is executed your store procedure needs to be a system stored procedures, instead of...
September 18, 2002 at 12:35 pm
Since I don't have 6.5 I really don't know what your problem might be. I would suggest you review sp_Msforeachdb code to determine exactly what the command is that...
September 18, 2002 at 9:19 am
Another possible solution would be to have a insert and update trigger that would update the [TEST] column thu1.CustID + 1 from the inserted table.
Gregory Larsen, DBA
If you looking...
September 18, 2002 at 8:26 am
If you run:
EXEC sp_Msforeachdb "EXEC sp_spaceused"
You get the output for the same datbase over and over again, since sp_spaceused runs in the context of the current database. Now if...
September 18, 2002 at 8:19 am
Bummer.....
You will need to re-install SQL Server to change the case preference, and then reload your database.
Sorry to be the bring you bad news.......
Other option might be to DTS your...
September 18, 2002 at 8:08 am
Good Idea. I'm working on retrofitting my report process and other automated DBA process to run from a single server and monitor multple servers. I also am having...
September 18, 2002 at 7:38 am
I'm not really sure that SQL.LOG is. I think someone thought is was a transactionlog associated with a database. I'm not sure. Can you tell me what...
September 17, 2002 at 5:04 pm
That would be sp_detach_db. Is SQL.LOG really a transaction log for a database?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
September 17, 2002 at 4:55 pm
Your computed column can be a noncomputed column name, constant, function, variable, and any combination of these connected by one or more operators. So possibly this would work for...
September 17, 2002 at 4:52 pm
You might try creating a backup device that points to the network backup device, and then restore from that backup device you defined.
Gregory Larsen, DBA
If you looking for SQL Server...
September 17, 2002 at 1:35 pm
So did it just not start? Have you looked in the LOG directory at the ERRORLOG file to see if there was some hint as to why the service...
September 17, 2002 at 1:33 pm
What exactly is the error message you are getting?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
September 17, 2002 at 1:17 pm
Viewing 15 posts - 796 through 810 (of 907 total)