Why are you using an XML in the select with for xml clause? The for xml clause is meant to be used when you take a tabular data and...

You need to add apostrophes to your dynamic SQL. Instead of the line:

Select @bank = @bank + '','' + bank + '''' -- In the second step taking bankFusiCode...

It’s been a while since I opened a text file using T-SQL, but when I did it, I used the bulk provider and was very easy to do it. ...

Actually...

Can you find out what those processes are? Are they jobs that were configure? Can you see the name of the application that uses xp_readerrorlog? Can you...

There are few strange things in your post. Xp_readerrorlog doesn’t change any data, so I don’t see why there should be any rollback. Can you post what you...

The log backup logged the alter database statement and also modifications to the system’s metadata tables that reflect the database’s modification. It didn't have to copy/backup the files' pages....

While I agree that we should use the new syntax, I don’t think that the error message was caused by using the procedure. Most chances are that you already...

Here is one way of doing it. Take into consideration that you showed us an example and didn’t write any specification, so the example works on the dataset that...

Here is a query that can check the query plans that exist in the cache and show you the queries that use most CPU. Take into account that if...

Check if you defined a table type parameter that uses this schema.

Adi

Have a look at sys.dm_io_virtual_file_stats. It has all the information that you are asking for.

Adi

drew.allen (11/11/2011)

---

Adi Cohn-120898 (11/11/2011)

---

One way is to calculate the number of days that passed since your date, then divide it by seven and multiply it by seven. Since the...

Personally I don’t like doing things like that, but it can be done with the over clause. The code bellow is based on AdventureWorks database:

select ProductID, SUM(ActualCost) from Production.TransactionHistory...

When I need to do it, I use UNC path (\\MyServerName\Dirctory\File.bak)

Adi