Viewing 15 posts - 46 through 60 (of 190 total)
Rank1_nj (6/27/2011)
I have a query that works fine. But as I started adding more records to my table, I saw that it wasn't working properly. Here's my query
Select
datediff(d,Start_Date,End_Date)...
June 27, 2011 at 3:00 pm
if something is raising Error: 18456, Severity: 14, State: 38. State 38 means user doesn't have access to database it is trying to connect to; part of it's connection string...
June 3, 2011 at 1:29 pm
Raymond van Laake (5/26/2011)
However, one issue!
I would like to use the secondary server for reporting. When...
May 26, 2011 at 1:16 pm
TheHose (4/11/2011)
April 12, 2011 at 1:07 pm
shiv-356842 (4/10/2011)
we cant take differential backups we have only take every day 12:00 AM full backup and every 15 teen mins T-log backups.
Just curious: why you can NOT take diff...
April 12, 2011 at 12:00 pm
FYI - I believe the SAN company whose name starts with N does a restore on another LUN and then a checkdb on the database after it is backed up.
This...
April 12, 2011 at 11:56 am
For FUNCTION, when it is a TVF, you have to use "GRANT SELECT". Otherwise, "GRANT EXEC".
April 11, 2011 at 3:08 pm
gsc_dba (3/24/2011)
So ALL of your SSIS tables are created in the Staging schema...
In response to:
I do...
March 24, 2011 at 1:57 pm
jolan.mahinay (3/13/2011)
March 14, 2011 at 2:29 pm
What you saw is CORRECT. And I am sure you know the structure of non-clustered index: the leaf level must have a clustered index key attached (if the clustered index...
February 17, 2011 at 10:17 am
The SQL Service account should be domain account with permission to the network shared folder. Or you have add the service account explicitly to access the network shared folder.
February 16, 2011 at 1:39 pm
homebrew01 (2/10/2011)
I just changed the Service account to LocalSystem, restarted, changed to my new SQL Service Account, restarted,...
February 10, 2011 at 2:26 pm
David Benoit (1/13/2011)
January 14, 2011 at 1:08 pm
Viewing 15 posts - 46 through 60 (of 190 total)