And another way is to use DBCC command as shown above and re-seed the value after the table gets created.

You will have to form a string and then execute it and you would also need to use global temp table then rather than using a local temp table (don't...

You are welcome Ben.

Since you are operating under the default isolation level of READ COMMITTED, another thing that you may want to look into for your SELECT statement(s) is the...

Yes, please use the Oracle OLEDB provider (OROLEDB.Oracle) rather than using MSDAORA. Microsoft hasn't done any enhancements to MSDAORA and in the tests that we had done, the Oracle...

The problem that you are running into is that of an orphaned session. Since the application program was not able to communicate cleanly to SQL Server, the engine was...

Calling the DB2 procedure directly based on openrowset/openquery can lead to performance issues not to mention the limitations that you might encounter because of data-types, error handling etc..  One way...

You can - but I would not advise doing that.  You should configure each instance to use all available CPUs on that box for best performance of your applications.  In...

The question is not clear.  Are you saying can you have a named instance without having a default instance?  If that is the question, then yes, you can.

Use a single tick to escape it if you want to insert the quote, example:

create table testcase (col1 varchar(100))

go

insert into testcase values ('One test '''' of inserting quotes ''''')

go

select *...

Yes, this is possible i.e. 2 servers, each running an active instance and using the other server to failover i.e. you would have 2 Active/Passive combinations.

You do have...

If your ID list is finite, then you can pivot the results like this:

create table pivot (ID int, Value Int)

go

insert into pivot values (1, 100)

insert into pivot values (2, 200)

insert...

As peter said, use a CASE statement. However, if the logic is very complex i.e. if it is not simple conditional CASE statements and will involve complex sub-queries within...

You are using global temporary tables (the ones with two ## signs). Global temp tables are dropped automatically when the session that created them ends AND no-one else is...

You can schedule a database job that runs a lightweight check on the processes and in the event of :

a) blocker/blockee situations,

b) open transactions for a long time,

c) hung sessions

It...