I dont think i understood your requirement fully.

I guess u want to insert some records in a table which is already having records from the past year. In this case...

Instead of killing all active sessions, you can fire this simple statement to...

use [server2\YourInstanceName] without quotes.

venu_ksheerasagaram (7/24/2009)

---

Hi,

I have an issue here which goes as follows;

1) How to give dbo_access to a user?

2) What is the use of schemas?

3) What is the difference between Schemas...

Patricia Johnson (7/24/2009)

---

After posting I found that the application server which has a service running on it to connect to the database server is what is initiating the .net sqlclient...

joshua.aanderson (7/24/2009)

---

I had a customer take tables from a test environment and import them to there live environment.

Is there an easy way to undo that without comparing the data in...

Lynn, TAT=Turn Around Time (not a defined phrase as per the SDD-service delivary document, but we use it for TTO+TTR).

eg. in one of our deliveries, Time to own the tickets...

If you want to restrict the number of characters to 7, you may want to include the check for length as well.

create table test

(

id int identity(1,1),

tag varchar(10) constraint ck_test check...

I created a test table with tag column...

create table test

(

id int identity(1,1),

tag varchar(10) constraint ck_test check ((upper(tag) not like '%[I-O]%') and (tag like '%[0-9]%' or upper(tag) like '%[A-Z]%'))

)

see if this...

I...

I dont think owning a database by sa or any other user should be of any concern. What matters is who is performing 'what' in your database. So creating users...

I'd agree with Steve's concern of backup up your database in a single file by appending files to it. If something happens to the file, none of the backups will...

Express edition (which is free) might not be useful to you as the maximum database size if 4GB. Developer's edition or any other edition will allow you to attach a...

This is due to orphaned user name1.

check out for sp_change_users_login in BOL.

Following example from BOL Should help you.

USE YourDB;

GO

EXEC sp_change_users_login 'Auto_Fix', 'Name1', NULL, 'New_Password';

GO

thanks for the link. very useful.

we found that tempdb growth is due to a ssis job which is using tempdb heavily. We're waiting from the developement team for further updates....