Have you read through these two articles (related)

http://msdn.microsoft.com/en-us/library/aa337491(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms156034(v=sql.105).aspx

The fastest (and most accurate) is to query sys.indexes - example:

SELECT

c .row_count AS [RowCount]

FROM

sys. objects a

JOIN

sys. indexes b

...

I don't believe there's a way within SQL to prohibit the truncation of the strings when it's assigned to the variable. How is this proc called? If it's...

You will need to create a linked server to reference the example code FROM OPENROWSET('NAMEHERE',

The name used in the example is: 'MSDASQL'

Like already noted, "it depends" however, you can pretty easily add/drop articles from replication (I am assuming you are referring to transactional replication) if the immediate sync option is set...

I personally prefer SQL Diagnostic Manager (praying I don't get attacked from mentioning an Idera tool on here ;-)) - In my testing I liked the way the data was...

I would tend to agree with Fluffy :hehe: catch up on maintenance things, learn something new, read up on one of those articles I've had bookmarks to for several months,...

Do you mean on the SQL Server box itself? If so, no. If you are...

Thanks for the easy one! Should have been "can temp tables" be used in UDFs - that may have fooled a few :hehe:

Interesting...

Please post your full code causing the errors, including DDL for all the tables needed, and the scripts needed to populate at least a few rows into each table. ...

It works fine for me both ways...I dont get the error, seems to me you have something configured differently within your SSMS?

This assumes you have successfully set up and are able to use a linked server: SELECT

a.col1,

b.col1

FROM

LinkedServerA.DatabaseA.dbo.TableA

INNER JOIN LinkedServerB.DatabaseB.dbo.TableB

...

Michael T2 (12/13/2012)

---

if i take out

AND coalesce(txSubtype,'') <> 'BACKORDER'

no records are returned. thats why i am using the coalesce. Most of the records i need have a null...

Never tried FORFILES but this works well and is very simplistic EXEC MASTER.dbo.xp_cmdshell 'del \\YourUNCPath\*.*'

The reason nearly everyone on here will chine in on the use of NOLOCK (locking hints in particular) is primary because of the byproduct of using it altogether (dirty reads/potentially...