The...

That's refering to the allocation pages (GAM, SGAM, PFS). They're not actually objects, but they say which pages in the files are used, available and how much space on them....

bcronce (8/14/2008)

---

Last timeI created a web app, there was a procedure to test to see if incoming data was valid SQL and if so, to throw an exception. How does...

STATISTICS IO

and

STATISTICS TIME

are the best for this. (both SET options)

Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic552520-146-1.aspx

My guess, there are too many rows returned for the index seek + bookmark lookup to be efficient, so unless the index is covering, SQL elects to scan the cluster.

Check...

Brandie Tarvin (8/14/2008)

---

They need a better priority system than alphabetical. They need to be able to let you choose an option on how to set what default comes up....

The default basically means...

That's not a permission-related error. If you could post the exact error message, we could probably tell you whether or not it's a...

Depends on your table structure and what and who you need to mail. Put into the temp table enough info that you can then identify which salaries you updated for...

First thing, please double check your version. SQL Server 2000 is up to service...

bhuvnesh.dogra (8/14/2008)

---

If i add domain\sqlman as remote login it gies below error:

Executed as user: DOMAIN\SQLMan. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000] (Error 18456). The step...

Perhaps write a stored procedure, keep track of the employees that you've updated in a temp table and then send the mail at the end of the procedure.

It would help if you said what error they were getting.

Sure. Untested, but this should give you an idea.

UPDATE SomeTable

SET RMFP = CASE uid WHEN 1 THEN 15 WHEN 7 THEN 18 WHEN 8 THEN 19 ELSE 0...