2003-07-10
PASS
RE: unknown processes
No they do not need to be running. Are they alwayy there? they shlould just "pop in and out"?
2003-07-10
1 reads
RE: Starting jobs from internet
Create a role in msdb and add the users or groups to that role which need to execute the job. Then add 2 lines to sysjobs_view: OR ((ISNULL(IS_MEMBER(N'MyJobExecRole'), 0) = 1) AND name like 'MyjobName%') Where MyJobExecRole is the name of your newly created SQL role and MyJobName is the name of the job.
2003-07-09
RE: tempdb log ig growing
I have found the following link helpful in trouble-shooting this problem in the past: http://www.wamoz.com/giant_tempdb.asp
2003-07-07
RE: Starting jobs from internet
Sorry .. I see you reformulated your question slightly. I still reckon that Andy's solution was good though. If you want to restrict running the job to certain users, it might be a plan to have the asp page pass in the NT_USER value to the table which is polled. Your polling job could then […]
2003-07-07
1 reads
RE: Role script
You may have to generate a script larger than intended and then extract the bit you want. In EM, right click on DB name, All Tasks, Generate SQL Script, General tab leave asis, Formatting tab uncheck DROP, Options tab check Script database users and database roles. Then Preview from the General tab.
2003-07-05
RE: PetCo.com Vulnerable to SQL Injection
quote: I'm not sure we can expect all software companies to adhere voluntarily to such high standards -- especially when doing so will cost them (in the short term at least). There needs to be a foil. I suppose that CERT/Bugtraq may fulfil this role (I'm not familiar with them beyond knowing of their existence […]
2003-07-03
1 reads
RE: collation prb
Yes it helps me. My server is SQL server 2000. But I cannot change collation when the column is indexed and other fun alert of SQL server. How do you do the changing of the old collation name of all tables ?
2003-07-01
1 reads
RE: Computer Security Unveiled
Pretty funny! Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-30
RE: Clustered Data Server
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-30
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers