Viewing 15 posts - 10,456 through 10,470 (of 26,489 total)
Just remember, if the witness server is located in the remote data center with the mirror server, and you lose communication between the data centers that the mirror server will...
July 26, 2012 at 8:10 am
laurie-789651 (7/26/2012)
Oops... make that '2012 Jul 18 23:59:59:997'!BTW DateTime is only accurate to 3 milliseconds.
For a specific day, use Anthony's suggestion (I think I read somewhere that in that case...
July 26, 2012 at 8:02 am
Eric M Russell (7/25/2012)
I'm not a beer connoisseur and don't care for the small batch gourmet stuff. When I drink beer, I'm either drinking Miller High Life.
Or? Your statement...
July 25, 2012 at 5:04 pm
Duplicate post. Please post all further responses here
Please, do not cross post as it just fragments any responses you get from members.
July 25, 2012 at 5:01 pm
Duplicate post. Please post all further responses here
Please, do not cross post as it just fragments any responses you get from members.
July 25, 2012 at 5:01 pm
bclyde-1080677 (7/25/2012)
July 25, 2012 at 4:50 pm
rangu (7/25/2012)
I have a SSIS package which imports data from a source excel to the Sql Server database.
I want this package to be triggered from Ms Access form button event.
For...
July 25, 2012 at 4:28 pm
Luis Cazares (7/25/2012)
You presented the first solution just because it would be a correction of the original query?
Because it seems to me that it would give terrible...
July 25, 2012 at 1:46 pm
SQL_NuB (7/25/2012)
Its returning me 0 for my counts
And you'd like me to do what? You didn't provide any DDL for your tables, nor sample data with which to load...
July 25, 2012 at 1:42 pm
Thoughts? It all depends on where you run the code. On my development VM the Quircky Update beats your rCTE every time. Using your code the QU...
July 25, 2012 at 1:38 pm
Vikrant S Patil (7/25/2012)
The following URL provides good information (including the script \command) for database backup copy_only option:http://www.mssqltips.com/sqlservertip/1075/copyonly-backups-with-sql-server-2005/
Hope this helps.
http://www.mssqltips.com/sqlservertip/1075/copyonly-backups-with-sql-server-2005/
July 25, 2012 at 1:11 pm
Vikrant S Patil (7/25/2012)
July 25, 2012 at 1:09 pm
With nothing to test against, try either of these:
select
x.Delay,
x.Cancel,
RentalPeriod
from
( Select RentalPeriod,
...
July 25, 2012 at 1:07 pm
rummings (7/25/2012)
If this helps... great... if not... I do appreciate your time looking into this.
Charlie
DECLARE @rc int
DECLARE @File_Exists int
DECLARE @Line_Nbr int
-- TODO: Set parameter values...
July 25, 2012 at 12:51 pm
Vikrant S Patil (7/25/2012)
you can take a look...
July 25, 2012 at 12:46 pm
Viewing 15 posts - 10,456 through 10,470 (of 26,489 total)