Viewing 15 posts - 316 through 330 (of 608 total)
octavuslimited (7/19/2013)
I'd be interested to know whether people think this is useful and what issues (licensing, security, traffic etc.) there might be.
The only issue I have is typing my server...
July 22, 2013 at 6:28 am
jshahan (7/18/2013)
I thought if you were working on the same box that had the database engine, you could always use local.
The box can host more than one instance of the...
July 22, 2013 at 5:05 am
How often are you backing up the log?
July 22, 2013 at 5:01 am
durai nagarajan (7/19/2013)
Sean Pearce (7/18/2013)
durai nagarajan (7/17/2013)
any other guess before i take it to the vendor.Select growth from SYS.MASTER_FILES where name = 'DBName'
32000
I would agree on contacting the vendor for...
July 22, 2013 at 4:46 am
http://msdn.microsoft.com/en-us/library/ms188917.aspx
Returns size and fragmentation information for the data and indexes of the specified table or view. For an index, one row is returned for each level of the B-tree in...
July 18, 2013 at 2:43 am
CREATE PROCEDURE prBlah
@DateParameter DATE = NULL
AS
SET @DateParameter = ISNULL(@DateParameter, GETDATE())
...
July 18, 2013 at 2:33 am
durai nagarajan (7/17/2013)
any other guess before i take it to the vendor.
Select growth from SYS.MASTER_FILES where name = 'DBName'
July 18, 2013 at 2:06 am
Microsoft Support
Moreover, such...
July 16, 2013 at 7:21 am
Depending on the drive you have chosen to install your Reporting Services instance, the physical path to the Log Files where you can search for errors is the following:
C:\Program...
July 16, 2013 at 7:06 am
Welsh Corgi (7/15/2013)
Am I missing something?
http://msdn.microsoft.com/en-us/library/ms179314.aspx
Use NORECOVERY whenever you intend to continue with a restore operation on the database. NORECOVERY takes the database into the restoring state. This guarantees that...
July 16, 2013 at 6:31 am
kapil_kk (7/15/2013)
What I did is use RAISERROR
RAISERROR('Invalid...
July 15, 2013 at 6:50 am
_nzrdb6 (7/12/2013)
fool recovery model
You need to backup the log first.
July 12, 2013 at 5:04 am
ScottPletcher (7/11/2013)
Sean Pearce (7/11/2013)
bert.hooks (7/11/2013)
Wow. Insults from an idiotic know-it-all.
Pot --> kettle --> black.
Excuse me for being defensive, but Microsoft products have been putting food on my table...
July 11, 2013 at 9:04 am
Viewing 15 posts - 316 through 330 (of 608 total)