Viewing 15 posts - 61 through 75 (of 187 total)
Restoring the database from one place to another should definitely not shrink the database in any way.
How are you checking the size of the database (file system, sp_spaceused,...
April 20, 2009 at 8:57 am
Warren Peace (4/16/2009)
Yes, DBMail works fine for me. SMTP info in the account is working.But why doesn't the following work...
EXECUTE msdb.dbo.sp_notify_operator @name=N'YOMAMA',@body=N'testing SQL notifications'
sp_notify_operator ends up calling sp_send_dbmail, so...
April 16, 2009 at 12:26 pm
Do you have reporting services set up on your network anywhere that could access the server? If so, it is incredibly easy to create a basic report that renders...
April 16, 2009 at 11:47 am
Just want to second ALZDBA. I have found Gerts solution to be far more reliable on SQL 2000.
April 16, 2009 at 10:45 am
Why these things happen, I am not sure, but I have seen something similar to this on our SQL 2000 servers as well. More than likely the session (currently...
April 16, 2009 at 10:43 am
Some of the things that I have been using it for on some of our lower level servers (that we do not have licenses for commercial monitoring tools) are to:
verify...
April 15, 2009 at 2:41 pm
Something like
select * from sys.sql_modules where definition like '%your string here%'
should get it for you.
April 15, 2009 at 10:07 am
Glad to hear it all worked out and was beneficial for you. Always a good feeling to see those queries drop from minutes to under a second, isn't...
April 1, 2009 at 12:16 pm
There is no real easy answer to this question. Enough is completely subjective when it comes to memory depending user needs, SLA's, etc...
However here is a great...
March 30, 2009 at 1:49 pm
Wow that is a really long time to do a SQL backup (at least in my experience). How big is the DB if you don't mind my asking?...
March 26, 2009 at 1:15 pm
sp_send_dbmail has an @query parameter. This parameter will attach the output of the specificed query into the body of the message.
March 26, 2009 at 12:42 pm
This may be one of those cases where you are kind of over the threshold of where a table variable is useful (there are no hard numbers on when that...
March 26, 2009 at 9:54 am
In the ideal world, I think the best bet is to have the tempdb files separated from each other and separated from the database files as well (basically each file...
March 25, 2009 at 2:04 pm
Given the code you have here (I am copying it in for my own reference)
SELECT
M.Surname,
M.GivenName,
A.StreetNumber,
...
March 25, 2009 at 1:51 pm
Glad to help. Good luck with the rest of it and definitely post back after you have your final solution in place.
March 25, 2009 at 11:55 am
Viewing 15 posts - 61 through 75 (of 187 total)