Viewing 15 posts - 5,251 through 5,265 (of 6,105 total)
If you gave the user ownership over all the jobs, yes the user could execute them if he/she was not a member of sysadmin. In that case, you will...
August 1, 2002 at 11:55 am
If puller is the information you want to insert, you could do the following:
INSERT INTO job_type
SELECT DISTINCT
puller
FROM users
K. Brian Kelley
August 1, 2002 at 11:51 am
It sounds like whatever problems there are, the rebuild may result in a data loss.
REPAIR_REBUILD will do the repair so long as all data is retained. This just leaves the...
August 1, 2002 at 11:47 am
It is frightening. Some of the recent vulnerabilities wouldn't be a big deal except permissions default to the public role. Great googlymoogly!
Of course, someone's figured out that if they can...
August 1, 2002 at 11:33 am
Is there the possibility of your stored procedure being executed by more than one connection at the same time? If so, are you using local or global cursors?
K. Brian Kelley
August 1, 2002 at 9:11 am
The system stored procedure sp_cursorclose is an internal system procedure. Typically when we want to close a cursor and remove it from memory we do the following:
August 1, 2002 at 8:42 am
In SQL Server, a database can span across multiple files. These files can be grouped into filegroups.
One reason you'd do this is to increase performance. For instance, if I have...
August 1, 2002 at 7:26 am
How well are other queries doing, such as SELECT statements?
K. Brian Kelley
August 1, 2002 at 7:14 am
I'm not seeing anything in Books Online about it, though I've been looking, too. I've found how to do it through EM. When you set the provider options, the options...
August 1, 2002 at 4:55 am
You'll need to join two system tables, sysobjects and syscolumns. To get the right name for the column, you'll have to know the id of the object. If you know...
July 31, 2002 at 8:48 am
Yep. The stored procedure encryption isn't very strong at all. It also makes you ask, "What's the point?" Someone has even gone to the point of putting the decrypt into...
July 31, 2002 at 8:18 am
Hrm. That's a peculiar bug. I can recreate it. A workaround would be:
DECLARE @ADate datetime
SET @ADate = GETDATE()
EXEC SP_NAME @rundate = @ADate
K....
July 31, 2002 at 8:15 am
You'll want to add the IDENTITY property to your column if it is a number column. The catch with IDENTITY columns is that you can add them after the fact,...
July 31, 2002 at 8:11 am
Here's the Microsoft KB article on understanding blocking in SQL Server 7.0/2000. It also has links to how to monitor blocking in both versions.
http://support.microsoft.com/default.aspx?scid=kb;en-us;q224453
The amount of information may be overkill...
July 31, 2002 at 7:40 am
One that is often referenced and usually on my bookshelf (it keeps getting borrowed) is Profession SQL Server (7.0/2000) Programming by Rob Viera.
K. Brian Kelley
July 30, 2002 at 2:45 pm
Viewing 15 posts - 5,251 through 5,265 (of 6,105 total)