Hi...

Yes go with what Craig suggested. Put tempdb on a separate drive(It'll be better if it is a RAID array and best will be RAID 0 which will give best...

Thanks Guys.....

I followed the below steps and its working fine.

1. I created two users with same name and p/w's on both the machines and added them to local administrators group

2....

Hello Kevin,

In net use q: \\172.16.10.96\sfs p@ssword /user:jhb_sfs_xp\sfsjhb

What is sfs, p@ssword, user:jhb_sfs_xp\sfsjhb

my user name is rohit and password is rohit

I'm not getting the syntax.

Rohit

When I tried this method, I got below error in my job history.

Executed as user: OAKSVR004\Prod1. The syntax of this command is: NET USE ...

Hello Kevi,

Can you explain your solution with some more description, as

The syntax of the command

net use q: \\172.16.10.96\sfs p@ssword /user:jhb_sfs_xp\sfsjhb

and what exactly you mean by

We created an SSIS...

HI,

Can you give some more information related to your server including the hardware configuration, sql server version and service pack, no of databases along with the sizes, no of users...

as per me the best way is to create the exact table in your database and then write a job in your server to sink up this table with the...

Rajan,

Both the servers i.e. SQL Server and the server where I wanna to take backup are stand alone servers and are not in any domain.

Now at both the server I'm...

Hello All,

This is really a very informative topic abput tables & views.

I'm having a query abt the same.

Can we update the data of a table through view? but what if...

Hello Kevin,

I'm able to access the network shared folder through windows and able to read and write the data, but when I'm trying the sme thru command prompt as u...

Hello Guys,

I'm also facing the same error and I've cross check that All my sql server services is running under the administrator login.

FYI: My boht the server i.e. The SQL...

Thx Guys for Replying my post....

Karl: If you compare the date & time in both the logs then u will find that as per application their is a occurance of...

And few more things.....

5. How should I know that I need to rebuild the indexes....I mean is their any command for this....to know the index fragmentation etc.

6. If I run...

Thanks a lot for your time and help.......

Rohit

Thanks for your reply,

Does the 'DROP EXISTING' works on primary key also i.e. if instead of the non clustered index, if I've created the primary key with non-clusteres index and...