Viewing 15 posts - 76 through 90 (of 327 total)
Hi Steve,
How do you get the time to reply so quickly when you're at Tech Ed? Anyway, it would be a very short article so here is an example script....
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 9, 2010 at 2:49 pm
Thank you Sanjay but I needed to get the port that a user connection is coming in from not the one(s) that SQL is listening on. The system view, sys.dm_exec_connections,...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 9, 2010 at 2:32 pm
Thanks Steve - sys.dm_exec_connections did it.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 9, 2010 at 11:15 am
Yep - that's exactly what I did and that makes perfect sense now :hehe:
Thanks
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 7, 2010 at 7:28 am
I thought it would be an empty result but wasn't positive decided to "test" and created the table. I got this message on executing the query:
Msg 8121, Level 16, State...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 7, 2010 at 6:45 am
Glad I could I help. It drove me nuts when I ran into it.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
May 12, 2010 at 10:03 am
This is an obscure bit of information that I always seem to forget with proxys. The SQL Agent account that runs the job will have a Temp folder. The proxy...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
May 12, 2010 at 7:14 am
Up to now, we have never moved a complete database. For the most part we use linked servers of ad hoc queries to pull data so I just didn't think...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
April 21, 2010 at 7:18 am
I was just about to roll my own when I came across this looking for an updated version of DumpSec. Thank you, Thank you, Thank You:-D:-D:-D
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
April 13, 2010 at 1:00 pm
What really burns me up about the "error messages" is that the people who write the compilers know exactly what the "error" is so why can't they just say so...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
January 27, 2010 at 7:26 am
Just to add to the knowledge base on this, we recently had the same issue. We normally "pull" data from Oracle into SQL but for this project it was the...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 10, 2009 at 7:14 am
I figured out my problem. I was trying to get the permissions on a Role. Wrong place. It all works well when using the proper objects such as tables, views,...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 7, 2009 at 3:18 pm
Hi Gary - dbrname was the database name being passed to the VB.Net sub. In the POSH script, $db is the database and $dbrole is the role in the database.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 4, 2009 at 9:53 am
You can use the GUI. In Object Explorer, click on the Linked Servers node and they should be listed in the Object Explorer Details. Select all the Linked Servers in...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
October 23, 2009 at 7:31 am
check this link:
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 28, 2009 at 1:12 pm
Viewing 15 posts - 76 through 90 (of 327 total)