Are you getting an error message? ...

In addition, the general users shouldn't even have QA/SSMS. The only people that should probably have these tools are DBA/Developers.

First, very bad to use sa from the application/websites. As far as disallowing sa from using QA (or in the case of SQL Server 2005/2008, SSMS), not going to...

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