Using MS SQL Server

rupdating duplicate entries with random numbers
Hi .. i am trying to update a table where if field contents any duplictaed entries than one of the field should be updated with random number which is unique so i can make all entries unique i searched a lot but couldn't find any solution which i could understand easily . is it very difficult in sql to update du... 13 Jul 2008 19:13

Changing the name in the ServerName column
Hi, I'm in the process of moving a database from a server running Windows 2000 SP4 to a PC running XP SP2. Basically, here's what I've managed to do so far: Made a full backup of the database on the server and then restored it onto the PC. Both running MS SQL Server 2000 SP3; though the server has Standard ... 10 Jul 2008 18:35

Schedule a Query
I need to run a rather large query and want to schedule it to run this evening. Is there a way to do that in sql server? (2005) Thanks, Scott ... 9 Jul 2008 17:50

Multiple attribute design that need to be searchable
Hello, I'm doing a school project and I'm supposed to be able to track campgrounds and their amenities. Here is some of the information I'm supposed to store: CAMPGROUND Number of Sites Number Summer Season End Date Summer Season Start Date Reservations Accepted Y/N F... 9 Jul 2008 13:42

Multiple attribute design that need to be searchable
Hello, I'm doing a school project and I'm supposed to be able to track campgrounds and their amenities. Here is some of the information I'm supposed to store: CAMPGROUND Number of Sites Number Summer Season End Date Summer Season Start Date Reservations Accepted Y/N Fi... 9 Jul 2008 13:42

Sql Server 2005 Replication
Scenario: CustDB from Server1 CustDB from Server2 i need the merge the data from both the database and store it on CustDb from Server3 using replication. sugest me the best replication model. Please suggest me how to do that in SQL server 2005. ... 9 Jul 2008 07:32

does this backup sequence commit all data to the database
backup log testdb with truncate_only DBCC SHRINKFILE (testdb_log, 100) WITH NO_INFOMSGS backup database testdb to disk = '\\DC01\Backups\DB01\testdb.bak' with init and does the shrinkfile command reduce the size of the ldf ? ... 9 Jul 2008 14:44

SQL problem - a variation on outer join
All, I am far from expert with SQL and have been unable to solve the following problem (stated in generic terms): I have three tables: 1. Employees - contains EmployeeName 2. Years - contains Year 3. Earnings - contains Year, EmployeeName, and Earnings I need a query that will return a row with the Year, E... 10 Jul 2008 18:35

More info Re: BACKUP LOG questions
Some more info: dbcc opentran says I have no open transactions dbcc sqlperf(logspace) says that I am using 4% of my log space for this DB, w/ a log size of around 314 megs... aj wrote: SQL Server 2005 SP2 Using SSMS, I've just backed up my transaction log (which is around 314 megs) on a smallish... 8 Jul 2008 13:06

BACKUP LOG questions
SQL Server 2005 SP2 Using SSMS, I've just backed up my transaction log (which is around 314 megs) on a smallish database. I purposely generated a bunch of dummy transactions to grow the trans log. I scripted the action in SSMS, and it said this: BACKUP LOG [test] TO DISK = N'C:\data\test.trn' WITH NOFORM... 8 Jul 2008 15:09