Global Sequencer

I want to be able to have a Unique sequence number accross multiple tables and databases (like havi…

FOREIGN KEY on Temporary Table?

Question: Is is not possible to add a FOREIGN KEY constraint on a local or global Temporary table? …

Question About DEFAULT

If I have the need to create a new field for a table where records already exist, and that new fiel…

Cannot Re-Publicate Tables

Hello all, Having an Issue setting up Merge replication on an NT 4.0 build 1381 SP 6 using Sql 7.0…

what is clustring

Simple case-sensitive groupings

Hi- I'm in the U.S. so I leave all the collation settings to the default. However, now I want to gr…

Sales Snapshot

I have a rather interesting task of creating a sales snapshot of our products for our DW. There is …

JDBC 2.2.0029, SP1

We may need to upgrade the JDBC driver for SQL Server 2000 to communicate properly with ColdFusion …

Tools for users to browse Cubes?

I'm curious to know what user front-end tools you all use to browse your OLAP Cubes? When Cubes fir…

Help with indexes

Hi,   I'm in the process of trying to optomise some search queries and was looking for some he…

SqlAgentMail does not work with win2003 server

  We just upgraded our database (sql 2000 sp3) to a new machine running windows 2003 server os…

Database owner with limited permission

Hi, Here is my case :     I have created development databases for each  develo…

ISNUMERIC()

If I use the following statement: CASE WHEN ISNUMERIC(Field) = 1 THEN CAST(Field as Numeric) ELSE 0…

How are usernames checked?

Hi there, How are new usernames actually checked? It might lead to irritations when you allow Jonat…

MS T-SQL Exercises

http://sql.ipps.ru/index.php?Lang=1