Datetime Manipulation

RE: 'Analysis of database' in Errorlog

• by James Travis

• SQLTeam.com

• Reply

If I come across anything else I will pass along.

2003-05-13

RE: TIMESTAMP not unique! help!

• by Mark_Holst

• SQLServerCentral.com

• Reply

Shame it happened on a production system, as I couldn't resolve it at my leisure. We had to manually update the record to force the Timestamp value to update itself. If I ever come across it on a development system I'll have to take advantage of the rare opportunity to check it out in more […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-13

1 reads

RE: SQL Profiler

• by ecarmon

• SQLServerCentral.com

• Reply

I am seeing this in SQL Profiler. Where can I see what these errors mean and what, if anything, should be done to correct them?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-11

RE: New Stored Procedure NAME

• by ganeshmuthuvelu

• SQLServerCentral.com

• Reply

??. Please help..

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-10

1 reads

RE: New Database creation

• by lucky-80472

• SQLServerCentral

• Reply

Hello Markus & Antares Thanks for the reply. If i receive an .mdf file, i can directly attach the database by providing this mdf file as per your guidance, so that the .ldf file will be generated automatically. Secondly, if i receive an mdf file with different name which belongs to the same database at […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-10

2 reads

RE: xp_cmdshell permissions

• by Said Khorramshahgol

• Database Journal

• Reply

I am not sure what a wrapper sp is. The xp_cmdshell is in a stored procedure that is being called from a parent sp. But when he runs it he gets an error. Thanks.

2003-05-09

RE: Log shipping to Two backup servers

• by ht2k

• SQLTeam.com

• Reply

Thanks. I was trying to delete the post but it does not have feature to delete your own post.

2003-05-06

RE: How to place tempdb in RAM?

• by James Travis

• SQLServerCentral.com

• Reply

No they feel it is well optimized and that there is no reason to do this. (Says so in BOL in their own words). If you are looking to see if you can speed it up a bit then consider setting up a seperate array (RAID 0 if not worried about drive stop stopping server, […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-05

1 reads