Viewing 15 posts - 4,906 through 4,920 (of 7,505 total)
Get rid of the cursor !
use this instead:
update P -- I supposed you want to modify UsgSvcMultiProvision.StatusID
SET StatusID = @ProvStatusID
FROM UsgSvc U
inner join Customer C
on U.CustID...
May 2, 2008 at 7:27 am
Job well done ! :smooooth:
Now determine what kind of backups you want to take, what kind of recorvery timeframe you need,...
(also re-evaluating your db-recovery-settings (simple/bulk logged/full)
Read books online for backup...
May 1, 2008 at 3:06 pm
your information schema check executes in context of the current database you are connected with !
If you are not connected to the @dbname, you are validating other data !
So
If...
May 1, 2008 at 2:57 pm
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...
May 1, 2008 at 2:52 pm
at least a fetch should have an into section
FETCH NEXT FROM Employee_Cursor into @colvar1,@colvar2
May 1, 2008 at 2:45 pm
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, ...)
May 1, 2008 at 2:36 pm
- 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,.. ....
May 1, 2008 at 8:55 am
- 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 😉
-...
May 1, 2008 at 7:55 am
nkm129 (4/30/2008)
Only think what is left here How to copy my backup to another disk.. I tried xp.cmdshell but...
April 30, 2008 at 5:18 am
Mike Hinds (4/29/2008)
I act as though my fellow IT workers (especially "superusers") are my biggest danger.
And they are !
That the top reason to remove builtin\administrators from your sql...
April 30, 2008 at 1:49 am
Oh yes, there can only be one clustering index per table.
April 29, 2008 at 7:52 am
- 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...
April 29, 2008 at 4:04 am
- do you use dynamic ports or fixed portnumbers ?
April 29, 2008 at 2:50 am
- 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'...
April 29, 2008 at 12:35 am
- 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...
April 29, 2008 at 12:33 am
Viewing 15 posts - 4,906 through 4,920 (of 7,505 total)