deadlock issues will occur if two or more users are trying to update the same record.

What you can do here is introduce concept of allocation. You can allocate the records...

select * into NewTableName from OldTableName where "put your condition here"

Refer BOL and msdn for more help.

The altered table structure should automatically propagate to the subsriber during next synchronization..

http://www.replicationanswers.com/AlterSchema2005.asp

Go through this link. You might hv to add an alias for the server running on named pipe....

http://support.microsoft.com/kb/265808

If you're importing to db for analysis, i've some queries...

If the spreadsheet is meant to store test scores, i dont find a studentID.

Assuming each row contains details of 1 student,...

Backup database youDatabaseName

To Disk ='YourPath'

does take complete backup.

Refer to BOL/MSDN for BACKUP for various options...

If you intend to create a sort of UAT or Test environment, you should backup your production database and restore that on the second server.

It is possible to pull out...

I dont know a query to pull exactly 1 GB, 100KB data considering the entire tables...

Do you want to take out sample records from each table?

whats the purpose?

I'm not sure if charindex supports wildcard....

--Assumption 1 - FirstName and LastName are both Not Null

--Assumption 2 - There are only 2 capital letters and they are first character of...

Thanks Gail. I admit i was little impatient.. my mistake.. trying to learn things faster... but it was blessings in disguise.. i did browse through several sites and learning quite...

It seems i'll get all possible errors thats possible :hehe:

I changed the account running sql server agent to LocalSystem and that resolved the issue. (i'm still unsure why it was...

Hi I've setup the snapshot replication.

I'm getting this error:

The process could not create file '\\OTTQWQ5CCRM01\Repl\unc'.

Can someone guide me the cause of this. All i can see is "access denied".

I've changed...

wow!! what an error!

In my enterprise manager, i had added the server's IP instead of name. It seemed it got confused that distributor is located on a different server and...

just wanted to add that the ip address and the server name in the error message are of server1.

I cant find of an option returning HH:MM AM(PM)

Try using 109

SELECT substring(convert(varchar,getdate(),109),13,5)+' '+right(convert(varchar, getdate(),109),2)