Please see the below link

http://support.microsoft.com/kb/173907

try

convert(datetime,'date',101)

1) Create a linked server

2) execute sp_start_job in msdb

eg

execute serverB.msdb.dbo.sp_start_job 'Jobname'

Check the size of the table as well. For smaller tables, rebuiding may not remove fragmentation.

Do you have backups? I think you might need to restore the database from recent backup.

See Paul Randal's blog below

http://www.sqlskills.com/blogs/paul/post/CHECKDB-From-Every-Angle-Can-CHECKDB-repair-everything.aspx

Edit: added Paul's link

jcrawf02 (6/23/2009)

---

jeffrey yao (6/22/2009)

---

I dare say if a data model needs to be tested under rigorous cases, the data modeler will "consciously" or "unconsciously" conform to normalization requirements. By "unconsciously",...

insert into dbo.changelog(

databasename, eventtype,

objectname, objecttype,

sqlcommand,eventdate, loginname)

values(

@data.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)'),

@data.value('(/EVENT_INSTANCE/EventType)[1]', 'varchar(50)'),

@data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(256)'),

@data.value('(/EVENT_INSTANCE/ObjectType)[1]', 'varchar(25)'),

@data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'varchar(max)'),

getdate(),

lol 😀

select count(*) from sysindexes where indid in (0,1)

Edit: This will return all tables including system tables.

Check

select object_name(id) from sysindexes where indid in (0,1)

If you need user tables only, use syobjects...

If your database size is small you can have a maintenance plan to rebuild all index for the database.

If its a large database, you may have to write your custom...

You can use maintenance plan to delete old backups.

But since you are appending backups to a single file, this may not be possible. While taking backups, select option to create...

you will get the spid of the blocking connection in sysprocesses.

use

DBCC INPUTBUFFER(spid)

to get the query

Which version of SQL server you are using?

You might be looking for rank() or row_number function

The condition will cancel each other.

Why don't you try '% customers %' assuming there will be a space before and after the view in your query

Here is a good article I found when I goggled

http://www.mssqltips.com/tip.asp?tip=1308