LISETH_T (7/15/2008)

---

I upload the application on three different servers (same code, same DB) and it works perfectly. However, when I publish it on their server it doesn't work. ...

go into add\remove programs and find SQL server 2005 then click remove.

the wizard will start and ask which instance you want to remove. select the radio button for the...

even if you dropped the PK and loaded the data as soon as you try and re create the PK it would fail anyway

why not alter the column and add the NOT NULL clause.

set the database to bulk logged recovery mode before executing the delete statements

for a filegroup to be of any use it would need to be spread across a separate array to the primary filegroup. Cant see any advantage to creating filegroups and...

well done!!

jsgault (7/14/2008)

---

I checked the firewall log & found lots of DROP UDP entries coming through so started fiddling....

just change fileid to 1 instead of 2 as below

select a.name, b.name as 'Logical filename', b.filename from...

if you have the original SP2 file sitting around on the network remove it and replace it with the latest so it doesnt get re deployed in future 😉

what disk set up (RAID arrays, etc) are you using on your SQL server

you don't need to detach the database

set the database offline using

ALTER DATABASE mydatabase SET OFFLINE

you can then do what you like with the disk files (even delete them). Move the...

what state do you require the replicated database to be in?

standby or full access

rinu philip (7/16/2008)

---

Hi, here's an example to explain : DBCC SHRINKFILE(testlog, 3)

Now if the target size is not reached with the above command, we can go on to truncate the...

Ratheesh

i would install SQL2005 developer alongside as a separate instance.

move databases, logins, etc to the new instance.

remove the old one when finished.

script the logins off using the MS script at

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

detach...

i'm using Redgate SQL Backup v5.x, its a great product offering good speed and very high compression. It also gives us 256bit encryption which we need for our backups. Very...