I agree that it's best to map local logins to an account on the remote server, rather than have all logins access the linked server using a default security context....

Peter Maloof (2/24/2012)

---

Eric:

Eric M Russell (2/24/2012)

---

For the past several years, I find myself walking up the theatre, reviewing the movie lineup, and then most of the time I'll just walk...

"Dolphin Tale" is one of the other hanful of movies from 2011, and it was one that me and the family enjoyed together.

For TV series, "Spartacus: Gods of the...

For the past several years, I find myself walking up the theatre, reviewing the movie lineup, and then most of the time I'll just walk away disinterested. The same goes...

Samuel Vella (2/8/2012)

---

One thing I would love to be able to do in SQL is this:

(Simple example)

select

A,

...

jyoti.patel (2/20/2012)

---

We would like to automate a way to restart SQL at 5:30AM local time every morning. We have an application that hangs until the SQL service is restarted. Cau...

dbapt605 (2/17/2012)

---

Is it possible to insert a large number of records into a fairly big table, and not have SQL Server lock the entire table against updates or other smaller...

When it comes to implementing a parameter driven process that performs multiple steps and then returns a result, that should generally go in a stored procedure, not a function.

It is possible to...

Ray Herring (2/21/2012)

---

Eric M Russell (2/21/2012)

---

Ray Herring (2/21/2012)

---

Hi Eric,

Great tool and very timely for me :).

I wonder about an addition. Of course in SQL 2008 Local Admins are not...

Ray Herring (2/21/2012)

---

Hi Eric,

Great tool and very timely for me :).

I wonder about an addition. Of course in SQL 2008 Local Admins are not automatically members of Builtin/Administrators, But...

jeanyvesR (2/21/2012)

---

Many thanks Eric , I have added the credential in MSDB db_ssisoperator role and it works fine.

Before this try I have found this MS kb : http://support.microsoft.com/kb/912911/en-us and a...

jeanyvesR (2/20/2012)

---

Sorry :crying:, but I going to run the job and I got following error message :

Message

Executed as user: Domain\PROXY_USER. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0...

The 2nd example will work, if your change the factor from an interger to a floating point like so.

select (cast ('1' as smallmoney) * 1000000000.0);

Charmer (1/24/2012)

---

Hi Friends,

i have table which does not have any date time column, but my need is to get some records depending on the date&time...is it possible...