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?

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...

anshu84onnet (1/27/2010)

---

thanks lynn i got your point i understand it but the only confusion was that we are typing

SELECT -- Have SQL return something to me

...

Michael Valentine Jones (1/27/2010)

---

WayneS (1/27/2010)

---

Michael Valentine Jones (1/27/2010)

---

There are two datetime string formats that are interpreted correctly with with any language setting.

With the first format, only the YYYYMMDD...

Are you the sys admin of the server you where you are trying to put the backup files? If not, talk to that person.

lptech (1/27/2010)

---

Someone besides a DBA really does need to understand SAN implications for database files. lets say I request three LUN's, one each for database files, log files, and tempdb....

Naw, I keep looking just to be sure! 😉

Glad you were able to fix the problem!

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...

Could you repost the sample data as a series of INSERT INTO statements?

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....

Nevermind! I figured it out!

declare @ TimeVal time,

@ TotalTime time; -- space added between @ and variable name to allow...

Like this?

declare @ TimeVal time,

@ TotalTime time; -- space added between @ and variable name to allow code to post

set @TimeVal...

CirquedeSQLeil (1/27/2010)

---

Lynn Pettis (1/27/2010)

---

Alvin Ramard (1/27/2010)

---

Oh, before I forget Jason, we passed on to our local chapter membership the link to your blog about user group participation. That should...

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...

lmu92 (1/27/2010)

---

Lynn Pettis (1/27/2010)

---

Okay, I'm lost on how you are lost. Please, what did you miss? It...