Don't have time to help with the query itself, but I noticed you are using sys.sysprocesses. This is a SQL Server 2000 system table and is for backward compatibility....

One suggestion, you may want to try formatting your code to make it easier to read, and please use white space as it also helps with readability. When posting...

Eugene Elutin (5/9/2013)

---

Lynn Pettis (5/8/2013)

---

Eugene Elutin (5/8/2013)

---

Actually you can, if you really want or need to!

You should use cursor datatype in output parameter of your procedure. Here you will find...

Eugene Elutin (5/8/2013)

---

Actually you can, if you really want or need to!

You should use cursor datatype in output parameter of your procedure. Here you will find a sample:

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

Should, also mention...

dwilliscp (5/8/2013)

---

...

I have found one other strange thing..

The outer join has data in the columns for details_2, so I do not understand how in the heck it is doing the...

And don't forget to post the expected results based on the sample data you provide. That will help with testing.

Kbear (5/7/2013)

---

OK - changing it through management studio really didn't change it but the syntax with [ ] around the offending part of the schema name worked. Thank you.

Still would...

Sean Lange (5/7/2013)

---

Kbear (5/7/2013)

---

I am trying to use the alter schema statement on a table with this name:

ABC\genn.smith.itemresults

with this statement

ALTER SCHEMA dbo TRANSFER ABC\genn.smith.itemresults

and I get this error:

Incorrect syntax near...

Edit: Wrong Thread

Script the table, change the schema to dbo, run the updated script, use a simple insert script to move any data from the old table to the new table, drop...

Could you please post the error message you get when the job is already running and the SQL attempts to start it again? Please be sure to post the...

cygne17_2 77208 (5/7/2013)

---

hi,

my user1 exist only in the msdb database.

I tried but it not working:

use master

go

GRANT SELECT ON sys.database_mirroring TO user1;

go

Msg 15151, Level 16, State 1, Line 2

Cannot find the...

With nothing to do any testing with, give this a try:

WITH BaseData(

Class,

Date_Entered,

PMmiles,

RO,

...

hany.helmy (5/5/2013)

---

I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!

Any explanation dear...

cygne17_2 77208 (5/7/2013)

---

hi,

I want to grant select on sys.database_mirroring to a monitoring user.

When I did this:

use msdb

go

GRANT SELECT ON sys.database_mirroring TO user1;

go

I received this error:

Msg 4629, Level 16, State 10,...