Viewing 15 posts - 91 through 105 (of 262 total)
And thank you Microsoft for turning something that used to be so beautifully simple into a convoluted mess.
That would be an incorrect statement. In SQL 2000 this "simple thing"...
October 2, 2008 at 11:31 am
Chris,
I would assume that ordering a 32 bit version of the same media would be an ideal way. It is completely legal and would cost you (if any) around $5.
Meanwhile...
October 2, 2008 at 11:26 am
No. Beginning from SQL 2005 security for Agent changed.
When you run a program from a SQL Server Agent job, that running process has the permissions of the execution context configured...
October 2, 2008 at 11:09 am
And as I understand it, a job runs under the security context of the job owner....so a job owned by cbsdba
You didn't specify the version of SQL server you...
October 2, 2008 at 10:51 am
Client connectivity tools installation is not licensed.
Licensing is going either on a "per connection" basis or "per CPU" of the server basis.
October 2, 2008 at 10:22 am
If on a security tab of a linked server you choose "Being made using current security context" - then you will receive an error described above.
Click on "Be made using...
October 2, 2008 at 10:19 am
Don't really understand why are you trying to over complicate your own task?
Since your requirement is stating a "semi fresh, one week old data", just restore a last, 1 week...
October 2, 2008 at 10:08 am
John,
the only difference between running sproc from Query Analyzer or from Job is a security context.
In query analyzer you are running your script under the current connection security context.
When running...
October 2, 2008 at 9:26 am
It's tough to say without knowing definitions of your views...
However, from the top of my head: if your view1 and view3 are using data from more than one database, attempt...
October 2, 2008 at 9:04 am
Phil,
if your jobs and alerts are not using NetSend, then you can either ignore this message or try to trace Event Viewer (Event log) for accompanied error messages.
There is a...
October 1, 2008 at 2:24 pm
PW, you are actually comparing running dynamic SQL against running a stored procedure. Using dynamic SQL within a stored procedure will have the same execution plan...
October 1, 2008 at 10:16 am
Sorry,
I didn't understand your original question then.
To make a long story short, I am using a simple rule of thumb:
If you can avoid using dynamic SQL in stored procedure -...
October 1, 2008 at 9:35 am
Webopedia definition:
In programming, a constant is a value that never changes. The other type of values that programs use is variables, symbols that can represent different values throughout the course...
October 1, 2008 at 8:45 am
If the Agent's trying to send, it sounds like you may have jobs configured for netsend notification
...or an alert
October 1, 2008 at 8:37 am
Viewing 15 posts - 91 through 105 (of 262 total)