Viewing 15 posts - 4,171 through 4,185 (of 7,496 total)
vikas bindra (1/8/2009)
I beleive sp_sendmail is not available in SQL server 2000. In 2000 you will have to use xp_sendmail.-Vikas Bindra
I'm sorry for the typo :blush: ..... didn't use it...
January 8, 2009 at 5:37 am
did you try this ?
CREATE TABLE #StaffTimeRecord
(
StartTime DATETIME
, EndTime DATETIME
)
GO
set nocount on
INSERT...
January 8, 2009 at 5:30 am
polo.csit (1/8/2009)
How to send the email throught the sql server 2000
please post in SQL2000 forum for SQL2000 questions.
Check out sp_sendmail
better even (because it uses smtp mail and no client is...
January 8, 2009 at 4:29 am
just a little side note:
If you are using SQLaccounts (non-windows accounts) for you database, you'll have to resync them with you new server.
You can migrate userid's and passwords using...
January 8, 2009 at 1:54 am
RBarryYoung (1/7/2009)
They sure don't say much about it though, do they?
Indeed, looks like a moment where a dba just quickly mumbles "and there was this little other thingy we fixed...
January 7, 2009 at 1:48 pm
jeffrey yao (1/7/2009)
WOW, that sounds a bug of sql server 2k5 itself. I am glad we have SP2 + CU10. 🙂
keep in mind, if you go to SP3, you must...
January 7, 2009 at 1:45 pm
Perry Whittle (1/7/2009)
ALZDBA (1/7/2009)
Truncation usually occurs after each checkpoint but can be delayed under some conditions
this is the key here, it should and generally does but there can be instances...
January 7, 2009 at 1:42 pm
What's your db collation ??
(case sensitive , accent sensitive, ... ??)
January 7, 2009 at 11:49 am
Perry Whittle (1/7/2009)
as i understood it, recovery interval option will make regular log truncations by issuing checkpoint, but in severe cases where transactions over run...
January 7, 2009 at 11:46 am
- Set up your service account security decently.
Give each instance its own set of accounts, also keep at least sql-user-passwords different per instance.
- also keep in mind, by applying e.g....
January 7, 2009 at 11:32 am
Still you need to investigate why there is no range joining for ranges that deffer only 1 day (end to next start).
I've messed around this procedural code, and all matching...
January 7, 2009 at 6:05 am
GilaMonster (1/7/2009)
...Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
Aarch... yes, overlooked...
January 7, 2009 at 3:17 am
You need to dig deeper into the backup file content.
Can you post the results of
restore headeronly
from disk=...
RESTORE VERIFYONLY
from disk=...
restore labelonly
from disk= ...
January 7, 2009 at 3:12 am
Kinnari Thaker (1/7/2009)
Restore Databasefrom disk = 'D:\Dr. Acharya\ManCanDoSql.bak'
I also tried the above command with 'with replace'
It should be :
Restore Database YOURDBNAME
from disk = 'D:\Dr. Acharya\ManCanDoSql.bak'
But you should first figure out...
January 7, 2009 at 2:14 am
Viewing 15 posts - 4,171 through 4,185 (of 7,496 total)