Viewing 15 posts - 5,806 through 5,820 (of 6,400 total)
db_executor must be a role which was created by yourselves as its not a standard db role.
depending on what the db_executor role rights are depends on what they can do.
if...
February 24, 2012 at 4:27 am
Raghavendra Mudugal (2/24/2012)
I just installed SP1 on the vmbox running SQL 2008 R2 and can see these objects accessible.
Just wanted to know, now I see...
February 24, 2012 at 4:22 am
Thanks Cadavre. Touch wood, not had a problem with sp_MSForEachDB so far, but thats not to say that I wont in the furture.
I'll review your script and build...
February 24, 2012 at 4:07 am
as its sql 2005 i take it you have configured IIS correctly first and followed to link provided.
are you trying to install SQL 32bit or 64bit and is your server...
February 24, 2012 at 2:53 am
Raghavendra Mudugal (2/24/2012)
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with...
February 24, 2012 at 2:45 am
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
Viewing 15 posts - 5,806 through 5,820 (of 6,400 total)