you cannot retreive the password;

but you can pass the crendentials from the domain to the SQL server(is the SQL server on the domain?)

you would get rid of your SQL logins...

if you can install a CLR, that's the way to go; there a re a number of examples out there ,

i personally like fellow poster Elliot Whitlow's contribution on http://nclsqlclrfile.codeplex.com/

one...

it's "kind of" possible with some javascript hacks that are easily worked around by any end user...what are you trying to do? prevent Right Click...View...Source? that would not stop anyone...

Al Cook (11/10/2011)

---

Hi,

If I grant execute permissions to a procedure, do I also need to grant permissions to any underlying tables that procedure uses? Or does the user(s) automatically...

the profile you setup for database mail contains the "from " address;\for multiple addresses, the @recipients parameter expects a semi-colon delimited list of emails:

EXEC msdb.dbo.sp_send_dbmail

...

dave.chapman (11/10/2011)

---

Along those same lines, I want to back up or copy table and data to restore on a different server in a different database. Any good suggestions here?...

here's what i use, that finds FK duplicates regardless of any naming conventions...it uses row_number as suggested:

it also assumes only simple, single column FK, and not multi column FK's

SELECT

'ALTER TABLE...

Narayana Vyas Kondreddi generate insert statements script is overloaded with a lot of parameters;

for example

exec sp_generate_inserts 'myTable', @from="FROM myTable WHERE somevalue > 42"

or

exec sp_generate_inserts 'myTable', @ommit_identity=1,@from="FROM myTable WHERE...

you'll need to start the server in single user mode, and add yourself as an administrator again, then put the serve back to normal.

fromt ehre, you can connect and start...

if you know what offset your timezone is, you could calculate it;

for example in Miami Florida, i'm -5 from GMT , but when it's daylight savings, i'm -4;

by getting the...

davidshephard (11/9/2011)

---

Hi all,does anyone know of a free SQL tool that can scan a group of machines and expose the follwoing:

1.What version of SQL on each machine.

2.Service pack level

3.Number of...

i think something like this will help;

with the WHERE statement below, you get every objec that happens to have a reference to any column named "EmployeeNumber"

you might want to change...

are you using the two values for the BETWEEN ...AND operator?

if that's true, you could work around it with a case statement to make sure the lower value is used...

ideally, you just use a CTE to put the data together, and then summarize it.

show us the cursor and the expected output, maybe we can switch it to set based...

littlelisa1111 (11/8/2011)

---

The results are in a grid. I'm using SQL Server Management Studio if that makes a difference. My goal is once I get this to work to...