Hi

I have some hierarchial data that go to many levels (not 3 or 4 levels). Usually I keep them in a single table.

Iam using recursive CTE's for querying and...

Hi

check this out

http://www.mssqltips.com/tip.asp?tip=1088

Hi

I may be completely wrong here..

Could this have anything to do with table schema definitions ?

is ur SQL 2005 the default instance or is it a named instance ?

Roopa

You cannot use the standard RAISERROR statement in a function nor can u use the TRY...CATCH construct to throw a error.

How ever you can catch any error in the...

Do you have indexes on this table. Maybe they are getting reorganised by these updations.

Iam curious abt this.

Hi

If you are creating logins from SSMS you check the checkbox which says "Enforce password policy".

If you are using a script use the CHECK_EXPIRATION option of the "Create login" statement.

Hi

Going with single database is the better option. You can avoid porting/replication or any other methodology for keeping the 2 databases in sync. Also you can have reusabality of the...

thanks

Hi

I dont think u need views or triggers. Procedure should do the trick. Procedures give much better control over things than triggers.

Hi

From where will u get the data. R u porting from some other SQL db, or a text file or what?

Generall speaking insert the companies first and then insert one...

Hi

Replication it is or u can use SSIS for doing data transfer if that is applicable in your situation. Iam assuming that since they are lookup tables data changes...

Hi

Using privot is a good idea. since the number of columns can change your pivot query can be a dynamic sql.

Hi

to drop a default value

ALTER TABLE tablename

DROP CONSTRAINT constraintname

constraint name is the name of the default constraint.

we cannot create a new not null column without having a...