try something like this.

SELECT sys.objects.name, syscomments.ctext

FROM sys.objects INNER JOIN

...

I don't know if this is related to your issue or not, but I had same issue sometime back.

My production server was on Latin1_general_BIN collation and when I run a...

simple and good question but 13 points, I think is too much to give.

May be author thought of 13 figure because it stands for scary !!!

Thanks, David. I was suppose to post this error and question on forum and then I found your reply.

Thanks again.

I had the same issue sometime back and going through some blogs, I found this and it worked for me.

Try setting the IIS security level to low and it will...

Couple of other articles on Change data capture are here with good explanation. I read them sometime back and are very useful.

http://www.databasejournal.com/features/mssql/article.php/3720361

http://www.databasejournal.com/features/mssql/article.php/3725476

http://weblogs.sqlteam.com/derekc/archive/2008/01/28/60469.aspx

Agreed. That's the reason I would not implement 2008 in my project at least for...

Nice article and worth giving it a try for this new feature. Now, with this feature in 2008, I hope there would be less need to create a history...

I just talked to my manager about upgrading to 2008 from 2005 and his answer is "why rush on things, that to on a product from MS. Let's wait...

Good article with examples. Tried couple of them just now, but still I had a question? How many SQL DBA's use these commands and most of the info...

Kumar (10/1/2008)

---

hi Mak,

I'm too curious to know, how a single .bak file is listing 3 .mdf file.

Have you just made any change to the screen shot of the picture?

Let...

FNS (9/29/2008)

---

Yes I do need data as well as structure. Since the db is 20Gb I was rather hoping to avoid the backup to file, copy file (to another...

Mohanraj (9/29/2008)

---

Hi All,

I am having a stored procedure which will delete 22 millions of record.

Is there any quickest approach to deleting these records from the tables.

below is the query is...

Nothing I am aware of in SQL Server 2000. Use this for 2005.

declare @dbid int

--To get Datbase ID

set @dbid = db_id()

select object_name(i.object_id) object_name,

i.name index_name,

i.index_id index_id,

i.type_desc type_desc,

c.index_columns

from sys.indexes i...

I had used Spotlight on SQL Server Enterprise edition and also SQL diagnostic manager by Idera in different projects and both had given good results.

SQL diagnostic manager gives good historic...