Viewing 15 posts - 5,266 through 5,280 (of 6,041 total)
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....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 27, 2012 at 7:36 am
Peter Maloof (2/24/2012)
Eric M Russell (2/24/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 24, 2012 at 8:28 am
"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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 24, 2012 at 8:21 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 24, 2012 at 6:43 am
Samuel Vella (2/8/2012)
(Simple example)
select
A,
...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 23, 2012 at 3:12 pm
jyoti.patel (2/20/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 22, 2012 at 12:14 pm
dbapt605 (2/17/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 22, 2012 at 9:01 am
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.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 22, 2012 at 8:55 am
GilaMonster (2/21/2012)
You need to create the temp table outside of the dynamic query, meaning you need to know or be able to work out the columns beforehand.
It is possible to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 22, 2012 at 7:36 am
Ray Herring (2/21/2012)
Eric M Russell (2/21/2012)
Ray Herring (2/21/2012)
Great tool and very timely for me :).
I wonder about an addition. Of course in SQL 2008 Local Admins are not...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 21, 2012 at 3:16 pm
Ray Herring (2/21/2012)
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 21, 2012 at 2:17 pm
jeanyvesR (2/21/2012)
Before this try I have found this MS kb : http://support.microsoft.com/kb/912911/en-us and a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 21, 2012 at 7:55 am
jeanyvesR (2/20/2012)
Message
Executed as user: Domain\PROXY_USER. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2012 at 2:16 pm
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);
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2012 at 2:06 pm
Charmer (1/24/2012)
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2012 at 10:09 am
Viewing 15 posts - 5,266 through 5,280 (of 6,041 total)