Viewing 15 posts - 36,286 through 36,300 (of 39,810 total)
I'd use a view as well. Use separate dbs if they need to maniuplate the data separate from other users.
Steve Jones
June 13, 2003 at 10:08 am
Sorry haven't read it. Can you post your thoughts or write a review? We'd love to have it on the site. Send a review in email to me (sjones@sqlservercentral.com) if...
June 13, 2003 at 10:05 am
Remove guest from msdb and do not give him access to this database.
Steve Jones
June 13, 2003 at 10:00 am
The maintenance plan itself must be created, not just the jobs. PITA, and I'm sure there's a way to script out the plan, but I haven't bothered. They are pretty...
June 13, 2003 at 9:55 am
I don't ever see the *.ckp files in my backup folder. Checkpointing is an operation that writes out the transaction logs automatically and ensures data is on disk.
Steve Jones
June 13, 2003 at 9:51 am
Daily - Backups
Weekly - Integrity (dbcc), Patch application and testing.
Monthly - Baselining
Steve Jones
June 13, 2003 at 9:35 am
Don't use "select *", list out the columns you need. And only those columns.
Use ANSI syntax, makes things clearer, ex:
select a.colA, b.colB
from tableA a
...
June 13, 2003 at 9:33 am
sa might be mapped to a user. The login would be sa, the user something else.
select
u.name
, s.name
from sysusers u
inner join master.dbo.syslogins s
on u.sid = s.sid
Steve Jones
June 13, 2003 at 9:29 am
Very nice scripts. Need some modifications for me, but these are handy to have around.
Steve Jones
June 13, 2003 at 9:27 am
Which part of the maintenance plan? I suspect that either the plan didn't create correctly or there is corruption in sqlmaint.exe.
Have you dropped and recreated the plan? Can you create...
June 12, 2003 at 4:19 pm
June 12, 2003 at 4:17 pm
June 12, 2003 at 4:08 pm
Be sure the sql server is running. Also are you using NT authentication or mixed?
Steve Jones
June 12, 2003 at 10:50 am
We standardize on RAID 1 for OS, RAID 1 for logs, RAID 5 for data. Sometimes split that further. For one high end DSS system we went with RAID 10...
June 12, 2003 at 10:47 am
Use DTS to transfer the logins after that. Sp_change_users_login to synch users/logins if you need to.
Steve Jones
June 12, 2003 at 10:41 am
Viewing 15 posts - 36,286 through 36,300 (of 39,810 total)