Viewing 15 posts - 17,191 through 17,205 (of 26,484 total)
It depends on how you intend to use that other server in Canada. Can you provide more details as to what you are trying to accomplish?
January 28, 2010 at 7:10 am
Leading an IT department does not require hands on knowledge of every technology used. What is required is a general knowledge of both technology and the business. If...
January 28, 2010 at 6:01 am
anshu84onnet (1/27/2010)
SELECT -- Have SQL return something to me
...
January 27, 2010 at 10:12 pm
Michael Valentine Jones (1/27/2010)
WayneS (1/27/2010)
Michael Valentine Jones (1/27/2010)
With the first format, only the YYYYMMDD...
January 27, 2010 at 3:41 pm
Are you the sys admin of the server you where you are trying to put the backup files? If not, talk to that person.
January 27, 2010 at 2:48 pm
lptech (1/27/2010)
January 27, 2010 at 1:51 pm
Jason Tontz (1/27/2010)
It is always in the last place you look.:blush:
Naw, I keep looking just to be sure! 😉
Glad you were able to fix the problem!
January 27, 2010 at 1:39 pm
If that table is in the same filegroup as all the other tables, con't do it. If it was in a separate filegroup, then you could use filegroup backups...
January 27, 2010 at 1:36 pm
Could you repost the sample data as a series of INSERT INTO statements?
January 27, 2010 at 1:18 pm
Okay, gut feeling, network glitch or a permissions issue on the network share you are attempting to write the backup file.
Please go check the Redgate site for their error messages....
January 27, 2010 at 1:16 pm
Nevermind! I figured it out!
declare @ TimeVal time,
@ TotalTime time; -- space added between @ and variable name to allow...
January 27, 2010 at 1:12 pm
Like this?
declare @ TimeVal time,
@ TotalTime time; -- space added between @ and variable name to allow code to post
set @TimeVal...
January 27, 2010 at 1:05 pm
CirquedeSQLeil (1/27/2010)
Lynn Pettis (1/27/2010)
Alvin Ramard (1/27/2010)
January 27, 2010 at 1:00 pm
If you can get the date in the string in the format YYYYMMDD, SQL Server will always be able to correctly convert that date regardless of the settings of the...
January 27, 2010 at 12:57 pm
lmu92 (1/27/2010)
Lynn Pettis (1/27/2010)
lmu92 (1/27/2010)
Seems like I totally missed the point. Sorry about that... :blush:
Okay, I'm lost on how you are lost. Please, what did you miss? It...
January 27, 2010 at 12:49 pm
Viewing 15 posts - 17,191 through 17,205 (of 26,484 total)