pseudo columns ???

can you explain that with real table structure, am not sure how that will work.

thanks

Users may do different type of joins say for instance new view can be join with old view on a column which old view doesnt have , like new view...

Can i do this through SSIS pkg or BULK Insert to spped up my load.??

Few questions on BULK INSERT

1. Does a user need to be bulkadmin to do or just...

whats the difference ??

I am just worried if i do a join or union on that column...

can i do something like this.

I dont have any applications running and this happens when the user directly connects to sql server and exec query from query window from the remote host. All my sql...

I think only sysadmin kill any connection (spid) am i right? how can i track who killed the conenction at that time. Actually the user conencted to a remote server...

Are you sure tempdb will log transactions in the file which they have enough space, no matter how many files we have.

Experts, please comment on this.

thanks

Say If i have 100 secondary files (ndf), is there a way i can restore a database by looping through each file no matter how many files i have, because...

Can i do something like this..

I am getting syntax error here.

ALTER PROCEDURE [dbo].[SingleMode]

@DB as varchar(15)

WITH EXECUTE AS 'dbo'

AS

BEGIN

SET NOCOUNT ON;

ALTER DATABASE ' + @DB + ' SET SINGLE_USER WITH...

Also I expereinced in some situtaitons where database will not come out of single user mode, thats a danger for me just in case.

thanks

yeah i tried this but if a developer wants to run this from a sql agent job, how he is going to select database instantly.

Also when i tried dropping user...

But how could i setup this within a job. I want this to be done by the developers who does bulk data load.

For droping the user i thought of creating...

I need an empty shell of the existing database with all the tables empty.

yeah it worked. can u let me know what is the diffrence.

thanks