I think that this will do it, (at least the query's results have the same records that you showed as the results that you are looking for), but next...

If you want to know how to pass the parameters to the stored procedure, you do it the exact same way that you would do it if you were working...

For that you'll have to use trace or trigger or to use stored procedure to allow data...

For that you'll have to use trace or trigger or to use stored procedure to allow data...

Here is the query that I'm using. I found it once on one of the SQL Server forums, but I don't remember where.

SELECT name AS 'File Name' , physical_name...

The update statement has to do a table scan in order to find which record met the specified criteria in the where clause. Since the first process is still...

When you look at the job’s history, you can check the checkbox that shows the job’s steps. This will give you a bit more information about the error. ...

Your post is not very clear. Do you want to get only the records that have only numbers or do you want to get all the records but remove...

Casper (3/20/2009)

---

Thanks for the replies.

One more permission related issue: If I execute this: EXEC sp_addrolemember 'db_datareader', 'User_Name_Here'

It give the user SELECT permissions on tables , but not views.

How can...

When you create the database, you can decide how much the file should be increased. If you use the GUI the default is 10%. I have to admit...

SQL Reddy (3/19/2009)

---

Make the id column as identity and start the values from 2 with an increment of 1.Use dbcc checkident reseed to acheive this.

Then import the data from the...

Chirag (3/20/2009)

---

In BOL under Creating Indexes (Database Engine) section its mentioned that there can be 249 non clustered indexes per table.

But In BOL under Create table sections...

The answer has to be maybe. If you don’t violate the rules for ownership chain, then the answer would be yes, but if you did something that breaks the...

I also tried script # 2 and it worked with no problem at all. While you run it, can you check the DMV sys.os_waiting_tasks and see if you can...

Can you show us what you tried and what error you got? I’ve done if few times with no problems at all.

Adi