Be carefull when removing builtin\administrators.

First of all grant your dba(-group) sysadmin (windows) rights for the sqlserver instance !

for windows accounts, you'll have to grant serveraccess and access to the needed...

at least a fetch should have an into section

FETCH NEXT FROM Employee_Cursor into @colvar1,@colvar2

yes

That still may affect other database(s) if that db is being refferenced by one of your other databases.

(e.g. in a view , procedure, ...)

- Only if he shuts down the sqlserver service, it is safe to perform a disk copy, unless you are using softwares like red-gate sqlbackup or veritas sqlbackup,.. ....

- because you always learn stuff you can implement immediatly for local benefit.

- and because it is big fun to meet your peers in and out of geek city 😉

-...

nkm129 (4/30/2008)

---

Thanks mike and all other guys who has give grt explaination ...

Only think what is left here How to copy my backup to another disk.. I tried xp.cmdshell but...

And they are !

That the top reason to remove builtin\administrators from your sql...

Oh yes, there can only be one clustering index per table.

- dynamic ports in use ?

If an instance uses dynamic ports, it may receive another portnumber when it is (re) started !

Check your sqlserver errorlogs to figure out if a...

- do you use dynamic ports or fixed portnumbers ?

- do you rebuild the indexes on a regular basis ?

(if you have SQL2005 EE, you can do that online !)

- Check if you really need the 'distinct'...

- do you have more than one named instance on that server ?

- can you connect using the instances portnumber ?

- I have a similar issue with one server hosting...

I always use backup devices and withing a cycle (between full backups) have my log-bacups incremental.

Only very rare I've noticed backups failing because of the device.

We regulary test pit-restores and...

It is not mandatory to have a clustering index, but I'd advise to always have one.

did you try the "for each loop" container to get this doen (in stead of a script task)