Viewing 15 posts - 3,286 through 3,300 (of 6,401 total)
Your into the inner workings now of how SQL Agent passes the subject from the Agent alert system to sp_notify_operator. My best bet would be for you to create...
November 22, 2012 at 2:05 am
Scenario 1 - Yes, roles is the best way to manage permissions, as in your case if you wanted to make 1 change to what a user could do you...
November 22, 2012 at 1:54 am
You would need to loop through every database quering sys.database_role_members and sys.database_principals.
November 22, 2012 at 1:47 am
sp_helpfile if you want it file by file, instead of just a total DB size which sp_spaceused gives.
November 22, 2012 at 1:44 am
sanket kokane (11/22/2012)
k.thanigaivel (11/22/2012)
No, please try thisalter table Atest drop constriant PK_ATest
alter table Atest alter column id bigint
alter table Atest add constriant PK_Atest primary key clustered (id)
that isn't like you...
November 22, 2012 at 1:40 am
vikingDBA (11/21/2012)
November 21, 2012 at 8:21 am
This is the code that I use.
USE [DBA]
GO
CREATE TABLE [DB].[DatabaseFileUsage](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[DatabaseName] [sysname] NOT NULL,
[FileID] [int] NULL,
[FileSizeMB] [decimal](18, 2) NULL,
[SpaceUsedMB] [decimal](18, 2) NULL,
[FreeSpaceMB] [decimal](18, 2) NULL,
[LogicalName] [sysname] NOT...
November 21, 2012 at 4:30 am
You will need to ensure that you have CIFS ports open so that the file copies can take place, ports 135,137,138,139,445 also the SQL ports need to be open. ...
November 21, 2012 at 3:47 am
On the notifications area of the job, you have set it to email a operator if the job fails, correct?
If so you will need to ensure that you have enabled...
November 21, 2012 at 1:58 am
You will not be able to stop people who are sysadmins from looking at the database, people who are sysadmins have full control to do what they want when they...
November 21, 2012 at 1:55 am
Remember that Google (or other search engines you prefer) are your friend, all the information you have asked for can be found by a few searches on the internet.
1 -...
November 21, 2012 at 12:54 am
If it can be done set based do it set based.
Cursors have their place but getting the information you want here isn't one of them in my opinion.
November 20, 2012 at 2:44 pm
I wouldn't use a cursor that's just asking for trouble.
I will attach the copy of the script I use tomorrow which utilises the above script and inserts to a table.
November 20, 2012 at 1:15 pm
Just watch out for using undocumented features like sp_msforeachdb if you have special characters in your db name it can cause problems
November 20, 2012 at 12:39 pm
Yes you are, your xp_sendmail maps to sp_send_dbmail so you need to ensure you have database mail enabled and configured
November 20, 2012 at 12:36 pm
Viewing 15 posts - 3,286 through 3,300 (of 6,401 total)