Unfortuantely this has to do with the token passed during a windows session logon. This is why we use a domain for our server and us. Try logging into the...

It is considered safer and better to use the RAISERROR method than divide by zero. It is also considered poor programming to use divide by zero on purpose (standard practice,...

Here is ther SQL BOL version of that

quote:

---

Microsoft® SQL Server™ 2000 provides two primary mechanisms for enforcing business rules and data integrity:...

Also, it has to do with the order of execution. Triggers execute at the point of commit and have to rollback, this is why it can see the inserted and...

If I remember correctly the information is somewhere in the registry for the registered servers but I do not know off hand where.

"Don't roll your eyes at me. I will...

The biggest reason for this is vendors do not want to be responsible for any issue that could be related to other activity on the box. We have one app...

I would suggest using sp_refreshview as suggested and see if corrects. If does then you may have made a change to the tables referenced in the view that upset the...

Look at @@ROWCOUNT in SQL BOL. However with ADO depending on the cursor type there is a parameter of the recordset object .RecordCount that will work as well.

"Don't roll your...

Also in SQL Books Online there are several or so comparisons with SQL to ORACLE code for help. Anything specific you may need to ask. But I liked the WROX...

Note: on the openrowset or even a linked server using openquery back to itself has some major flaws. One I believe you have to turn on Data Access for those...

I would suspect that you don't have enough memory and a lot of large queries that need different data. If this is the case then the cache hit ratio will...

Then you will need to do a query transaction instead of a transformation. Otherwise use a query to truncate the spreadsheet and just rewrite the data to it.

"Don't roll your...

SQL 7 does not support user defined funtions. And you cannot use an SP inline with a Select statement.

"Don't roll your eyes at me. I will tape them in place."...

I believe this comes from a tape put in the drive that contained a previous backup not listed in the backupmediaset tables in msdb database. They can of course be...

Also, besides here which allows you to retain the copyright there are a handfull of other sites. The most popular site I can think of other than here is http://www.sql-server-performance.com...