Also check for any errors reported from the IO subsystem.

iirc there are commercially available shopping cart components for ASP.Net. May be cheaper to buy one of those than reinventing the wheel.

System tables are stored in the primary filegroup and cannot be moved.

You should be able to remove the second file if you first do a shrinkFile with the EmptyFile option

Likely that the log backup is damaged then. It's one backup that consistently fails? If you stop before that backup, bring the DB online and checkDB, is the database still...

Why the hell are you shrinking the database after rebuilding indexes? You may as well not bother rebuilding indexes at all since the shrink will fragment them probably worse than...

passivebyz (6/2/2010)

---

Hi,

We have all our applications in SQL Server 2005 SP3 and do not want to upgrade to SQL Server 2008 until this year end. Because we do not use...

you're trying to do a log backup while some file operation (file add, grow, remove) is in progress. As the error says, they cannot run together. Rerun the job when...

Identity

http://support.microsoft.com/lifecycle/?LN=en-us&x=2&y=13&p1=2855

Take a look through this article - http://www.sqlservercentral.com/articles/64582/

malleswarareddy_m (6/2/2010)

---

This query will give the result

select i.name as [Index],i.type_desc as [Index type],T.name as [Table name],C.name as [ColumnName]

from sys.tables T inner join sys.columns C on C.object_id=T.object_id

inner join sys.indexes i...

Open object explorer, connect to the server

Expand out database->tables->the table you're interested in-> indexes

You can write a query, the views that you need are sys.indexes and sys.index_columns. It'll take some...

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Why do you think you need a loop?...

Dependency info is only stored (poorly) for objects in the same database. You'll have to check for job dependencies manually (by checking the definition of the jobs)

EXEC xp_cmdshell 'bcp "SELECT * FROM [DB_SCG].[SHIVA].[TB_Category] " queryout "C:\bcptest.txt" -T -c -t,'