How are you creating the temp table? What kind of index are you creating?

If you do the following, you shouldn't have any problems:

Create Table #t1 (

id int primary key...

Is SQL Browser running?

gwade (5/30/2008)

---

A possible issue - maybe minor, maybe not depending on your user needs:

Getdate() returns a date time stamp including hh:mm:ss.000.

This is not an issue if your expiry...

Instead of messing around with DNS, client network utility, etc... I use the following, which is much easier to manage.

Declare @server nvarchar(50)

,@source nvarchar(50);

Set @server = 'aliasname';

Set @source =...

Kyle Neier (5/29/2008)

---

I've used the STATS_DATE function to determine the last time that statistics were updated. Issuing either "update statistics" or "alter index rebuild" modifies this date. Issuing a reorganize...

Warren Peace (5/29/2008)

---

Matt, Big thanks to you!

My next attempt to reclaim disk is to use Winzip commandline to script the compression of each .bak file on a nightly bassis after...

santhu (5/29/2008)

---

Hi all,

thanks for all your replys,

Database has set as unrestricted growth and every time increases by 50MB,

Full Backup is scheduled every night and Logfiles every 15 minutes

Recovery Mode...

When connected to that instance of SQL Server you can run: SELECT @@VERSION which will tell you what version of SQL Server you are connected to.

To identify what is available...

Yes - that will no longer be supported and the supported way is to change the recovery model from full to simple, then change it back to full again.

Either way,...

Warren Peace (5/28/2008)

---

Per MS this will be depricated. I use this to shrink my TX logs on Sunday mornings. Does anyone know what the replacement will be? I checked in...

Did this solve your problem? Please post back and let me know the results.

Thanks,

Jeff

And now a plug from our sponsors (I am not affiliated - I just use their products). 😀

1) Create a new blank database

2) Using SQL Compare by...

No - you need to keep the parameters, and add the local variables:

CREATE PROCEDURE bmssa.usp_VENDOR_ONTIME

@Date1datetime

,@Date2datetime

AS

DECLARE@BeginDt Datetime

,@EndDt Datetime

SET @BeginDt = dateadd(day, datediff(day, 0, @Date1), 0); -- round to midnight

SET @EndDt...

What is the recovery model for that database? If it is full recovery model, how often are you backing up the transaction log?

What are the mdf and ldf file...

Hammad khan (5/28/2008)

---

Thanks a lot for the reply. I have the job which run every minute to update and delete .

when the job is running , it's opening the transaction...