Viewing 15 posts - 5,806 through 5,820 (of 6,395 total)
Ah banking, now thats a whole different kettle of fish, you might have some problems with this due to the nature of the banking industry due to security regulations.
I would...
February 24, 2012 at 2:28 am
i would say no.
if the connection count is getting higher and higher, its likely that one of the apps isnt closing and disposing of the connection object properly...
February 24, 2012 at 2:24 am
ramyours2003 (2/24/2012)
thanks for sending , i would likeDB name, DB size, Free space ,used space
instead of geeting the file sze deatails separatley .
use...
February 24, 2012 at 2:16 am
anthony.green (2/24/2012)
sp_msforeachdb 'USE [?];select
DatabaseName = DB_NAME() ,
CollectionDate = CONVERT(DATE,GETDATE()),
a.FILEID,
[FILE_SIZE_MB] =
convert(decimal(12,2),round(a.size/128.000,2)),
[SPACE_USED_MB] =
convert(decimal(12,2),round(fileproperty(a.name,''SpaceUsed'')/128.000,2)),
[FREE_SPACE_MB] =
convert(decimal(12,2),round((a.size-fileproperty(a.name,''SpaceUsed''))/128.000,2)) ,
a.NAME,
a.FILENAME
from
dbo.sysfiles a'
Not a problem, its how I manage growth, it runs every day, inserts into a table,...
February 24, 2012 at 2:15 am
Didnt know about the output clause, thanks for that on Gail.
February 24, 2012 at 2:11 am
Nice question
I knew it wasnt in dm_os_nodes or dm_os_windows_info, so as it says to pick two, it had to be the top two.
Changed the top one to sys.dm_ser then let...
February 24, 2012 at 2:10 am
Do you have any DBA's or BI developers (forgive me if you are one, but not having BIDS usually suggests that your not as its a key tools in a...
February 24, 2012 at 1:51 am
did you only want SSMS?
Have you installed any of these features
DB Engine
Analysis Services
Reporting Services
Integration...
February 24, 2012 at 1:47 am
triggers are t-sql
you will need to provide sample data, DML and expected results in a consumable format so we can help you out and explan clearly what you need, please...
February 24, 2012 at 1:39 am
disable windows firewall on your servers
if your on the same LAN for Pri and Sec servers and there is no firewall inbetween then its open
if there is a firewall speak...
February 24, 2012 at 1:35 am
what you asking for is a trigger
take a look at triggers and the before update statement, you can then have an audit table
so for example i have the below table...
February 24, 2012 at 1:28 am
SQLKnowItAll (2/23/2012)
Figured it out...
SELECT *FROM msdb.dbo.sysmail_profile p
JOIN msdb.dbo.sysmail_principalprofile pp
ON p.profile_id = pp.profile_id
WHERE pp.is_default = 1
I have 4 accounts and 4 profiles, they all show in profile and principal profiles but...
February 24, 2012 at 1:13 am
sp_msforeachdb 'USE [?];
select
DatabaseName = DB_NAME() ,
CollectionDate = CONVERT(DATE,GETDATE()),
a.FILEID,
[FILE_SIZE_MB] =
convert(decimal(12,2),round(a.size/128.000,2)),
[SPACE_USED_MB] =
convert(decimal(12,2),round(fileproperty(a.name,''SpaceUsed'')/128.000,2)),
[FREE_SPACE_MB] =
convert(decimal(12,2),round((a.size-fileproperty(a.name,''SpaceUsed''))/128.000,2)) ,
a.NAME,
a.FILENAME
from
dbo.sysfiles a'
February 24, 2012 at 12:51 am
please attach a screenshot of the alert system tab by right clicking on the SQL agent in Ssms so we can see the settings being used to send notifications
February 23, 2012 at 11:58 am
you don't need a default mail profile so maybe that's why nothing is being returned from principal profile.
February 23, 2012 at 10:41 am
Viewing 15 posts - 5,806 through 5,820 (of 6,395 total)