Viewing 15 posts - 46,396 through 46,410 (of 49,552 total)
Tried google?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 3:49 am
I can't see anything in that script that would allow the user to modify stored procs. They'll be able to generate the edit script, but running the alter should fail.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 3:48 am
There is nothing in that script which will allow modification of stored procs. You'd be able to script them, but not actually run the alter procedure statement?
I notice that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 3:20 am
fyz (5/26/2008)
If necessary, I think you can try a utility called Advanced Access Repair to repair your Access MDB file. It works rather well for my corrupt Access MDB...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 3:12 am
Steve Vos (5/26/2008)
!!!!user x can execute stored procedures, but not modify. ==> I would realy like to enable this one.
Grant the user EXECUTE rights on the stored...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 3:08 am
What permissions do you have in that DB? Are you sysadmin or db owner?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 3:06 am
Please don't cross post. It just wastes people's time and fragments replies.
Direct replies to the following thread please:
http://www.sqlservercentral.com/Forums/Topic505786-8-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 3:03 am
A better solution would be to keep transactions short so that fancy locking hints aren't necessary.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 2:54 am
You don't need to change the server name.
When you made the backup, there's a box on the backup window that lists the backup destinations. If there is more than one...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 12:13 am
GSquared (5/23/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2008 at 2:34 pm
If you have a true deadlock, then you won't need to kill processes. SQL has a deadlock detector that will notice a deadlock condition, pick one of the participants and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2008 at 2:22 pm
My guess is that when you made the backup, there were two entries in the destination box.
If there were, then the backup was striped across the 2, and you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2008 at 2:18 pm
The collective wisdom of google seems to indicate it's a dBase file format, also used in Foxpro and a few other apps
http://en.wikipedia.org/wiki/DBASE#File_formats
Not particularly relevant to a thread on corrupt SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2008 at 2:10 pm
Table and index definitions please.
How many rows do the two tables have? How many does this query return?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2008 at 2:03 pm
bbop1322 (5/23/2008)
When you setup the trace, switch over to the Events Selection tab and ensure that the NTUserName and LoginName columns are coming back.
Providing the app's not using a single...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2008 at 6:42 am
Viewing 15 posts - 46,396 through 46,410 (of 49,552 total)