hmmm, different ways of doing it, you can always stick on profiler for a while and give them the trace file, filter it by the application. you can monitor...

what do you guys think of a 20 minute rapid fire round of questions which are based on exact details .... for eg.

Q: where do you set the permissions...

As Steve pointed out in his podcast, having plain text passwords for SQL Logins in memory is not a major threat and that too when only sysadmins can see them....

I am using the same procedure written by SQLFool for a 300 GB database .... I have ensured that the maxdop option is set to 1, since I dont want...

I asked this as i was wondering if there is some setting in driver used in connection string or something i .net thats...

yeah looks more like a monitoring tool ... but the question still remains ... is it causing any problems ???

not sure how to configure an alert for that ....

but you could set up a job to poll this memory counter say every 1 minute and put it into...

to begin with ... you could create a maintanence plan and add TSQL execute task, where you could add the code you were running inside your SQL job.

for each...

is it causing any specific errors/performance problems on your servers or you are concerned just by looking at the log file ??

3604 is used to send output back to the...

my understanding is that standard would be able to address that extra memory, but would...

I have also seen 60 and 90 days limits ... but i like the idea of a multiple of 7 .....

Whet i end up doing is that I have an...

normalization would be the way to go .... even with 275 columns still there and mirroring or log shipping is chosen over replication ...... its still a bad idea to...

hmmm ... looks like i need to revise indexing 101 🙁

my understanding is that clustered index only has column data not the row.... else if the whole row could be fit into a clustered index then Row by Agonising Row,...

you could do it by running a bcp command inside a stored procedure. you could see examples Here.[/url]

or search google for - using bcp in stored procedure to create...