Thanks. You made my day. I know it works in SQL Server 2000 but never tried it with SQL server 2005.

I don't think its possible. You have to restart mssql services to resize tempdb. Its possible with other user databases but not with tempdb. the way to...

After executing DBCC DBREINDEX command also try executing

Update Statistics 'Table name' with fullscan.

This would definitely reduce your dead locking issue.

If you have the old DTS package, then save it as a structured storage file and then open it in EM and save it with different name. Then you...

Not sure, but check if this query helps?

Create Table #t (

[constraint] nvarchar(255),

PKTable nvarchar(255),

PKColumn nvarchar(255),

FKTable nvarchar(255),

FKColumn nvarchar(255)

)

Declare @tblID int

Declare c Cursor

Read_Only

FOR

SELECT id FROM sysobjects WHERE xtype = 'U'

OPEN c

Fetch c into...

Try Red-gate bundle. http://www.red-gate.com/products/SQL_Doc/index.htm?gclid=CIq-vsXP6ZACFQwsOAodOUvxYw

Its also had 14 day trail. But you get what you want and it give you all information about server/database.

Can you explain the question in detail? Its too confusing.

DBCC MEMORYSTATUS gives you most info about memory. You can also check DBCC MEMUSAGE.

SET NOCOUNT ON

DECLARE @hr int

DECLARE @fso int

DECLARE @drive char(1)

DECLARE @odrive int

DECLARE @TotalSize varchar(20) DECLARE @MB Numeric ; SET @MB = 1048576

CREATE TABLE #drives (drive char(1) PRIMARY KEY, FreeSpace...

Thanks Carl. Cool script. Definitely worth saving in personal briefcase.

I wrote this script to find the recovery model of all databases on any server. But you can modify to your convenience to get the result you wanted.

Use master

GO

declare...

How big the database? If its a relatively small database with no high availability then you can reindex at day time but its prefered to do reindexing at night...

Use sp_grantlogin to allow a windows user to connect to SQL Server

Use sp_addlogin to allow a SQL Server login to connect to SQL Server.

a member of sysadmin and securityadmin fixed...

Do you have your login created with specific server role granted? If no, create login onto that server and add yourself to a server/database role.

From the post what I understand is you are loading the data of txt file to a table using bcp.

for datatime you can put getdate() as default value and for...