Can you give more details.

How did you uninstall sql server 2005.

with regard to sql server 2008, what is not working, do the sql services still exist, are they running. can...

Good article, thanks for sharing. all we need now is the other exams covered 😀

At the same time, I'm helping someone keep a job that they are quite possibly growing in to. I'm helping a company that might otherwise have to lay someone...

At the same time, I'm helping someone keep a job that they are quite possibly growing in to. I'm helping a company that might otherwise have to lay someone...

bear in mind that the trustworthy database property is set to off by default. to safeguard from threats from malicious assemblies and malicious modules. which is funnily enough what you...

add a password for the account

enable the account

remove the password if you want to

bladerunner148 (8/19/2009)

---

I got a list of zipcodes in excel that I need to import in Sql Server 2005. So, I have a file with dealerId and their zipcodes.

Sample:

DealerId ...

Krasavita (8/19/2009)

---

I am trying to clean some space and I don't know what are these, can I delete them?Thank you

C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\LOG – 2.27GB of files

C:\Program Files\Microsoft SQL Server\MSSQL.5\MSSQL\LOG...

if the database was not backed up via sql server. Is the server/machine backed up. Speak to your windows administration team.

abr_mah (8/19/2009)

---

dear all,

is the replication get rid of duplication

ex.

i have database offline

client1 and client2 work on database offline

say client1 and client2 save data in order table

client1 enter orderid=1001

also...

Congrats, on passing.

Just curious on the mix of questions. Did integration services feature heavily, or was it pretty evenly matched across all the technologies.

My integration services isnt one of my...

My Humble Apologies.

BAU - Business as Usual

which is what most Production DBA's do 😉

True but it is implied, I might let you get away with that one :-P, although I am sure I have actually seen the quote else where.

this is the link...

As for the 'lord and master' dba's who 'Dont want to be told what to do by managers', remember that your overall responsiblity is to the business, represented by management....

I think that we have met different kinds of management over the years with all due respect