i think you could use something like this

select CASE

WHEN datepart(week,getdate()) %2 = 0

...

I completely overlooked point in time restores, tuning, development, etc., some of the many things we do outside of backups.

george is spot on; getting a point in time restore...

Marios Philippopoulos (4/6/2009)

---

With the advent of third-party enterprise-level backup solutions, such as Symantec or CommVault, how justifiable is it to maintain that DBAs should still be the owners of the...

sounds like gift Peddie's comments might be right then: upgrading a service pack to get the MDAC and drivers updated;

dunno if it makes a difference, but in my shop we...

i do it very similarly, Vijaya Kadiyala;

i always use a staging table, because once it's in a table, it's so easy to analyze...

BULK INSERT or bcp can be your friend...

we don't know...it could be something in your code...maybe you have ignore_dups in your import?

if it's from an application,say from the client-server or web and a session times out....starting a...

like i said, each column can have a different table...if you have 40 columns in the view, you are asking for 80 total? is that right?

what is the exact query...

i know there are issues with getting a 64 bit drivers;

outside of that, I've always used a script to add my oracle linked server.

this syntax might help you, since it...

the easiest thing, thinking about it is to avoid trying to add the "source" as a part of the datarow and rename the columns in your view to identify the...

it's not clear what you want. you've got to show us an example of your expected output, because you can't really mix schema info with datainfo....

what query are you using?

since...

if you run the command

EXEC sp_depends YourViewName

it will give you two sets of tables: the first is the sources of the tables/views and columns that that view refernces to...

why is it every woman i meet on the internet is really a guy?

just kidding, and my apologies.

Goo point;

i know the default length is varchar(30), whenever i convert something numeric to varchar, i've always left it in the simplified form and allowed the default conversion to work,...

I like Lynn's a lot more; having a view with just a newid in it is more useful, since i could use the same view for other purposes.

my code was...

well the reason for the error is one of the columns in an integer; you have to explicitly convert an integer to varchar when you are creating a string like...