If it is production environment and if you need disaster recovery it is always better practice to keep auto grow property enabled on log file.

If it is Dev or test...

enable the auto growth property of the transaction log, and you should have sufficient space on the drive. hope this will help you.

here is the link 😉

http://www.microsoft.com/downloads/details.aspx?familyid=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en

In the management studio, access the login properties of FMUSER under the security and logins folder go to the user mappings tab you can see the actual mappings for the...

People are always willing to respond or help to people who try their best and if the fail to get what they need, I am sorry if I said something...

Try take a look at this article, linked articles in it

http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx

I don't know how much more money or anything else an MVP can make, I dont know how it make any difference.

But I am learning a lot and I...

Professional SQL Server 2005 Integration Services this is one of the good book for 2005 SSIS.

When you create a database it will create a copy of model database with new name and settings what every you set, and whenever a new database is created it...

Try This

declare @sql2 varchar(8000),

@dbname char(30),

@sql3 varchar(8000),

@sql4...

Try this

SELECT id, so.name, Rows FROM dbo.sysindexes si

INNER JOIN sys.objects so

ON so.[object_id] = si.ID

WHERE si.indid < 2 and so.Type = 'U'

ORDER BY 2

Hay WayneS let me...

It is a warning message, it occurs as row size of your temp table is grater than the size of the maximum row size.

If you can post the temp table...

Nagesh S-432384 (6/3/2010)

one more late response Jeff 🙂 I am in IST (in India) so I will be...

If you have done In Place upgrade you cant access, if you have done side by side upgrade then you can.

Nag

one more late response Jeff 🙂 I am in IST (in India) so I will be always late...