Forum Replies Created
Viewing 15 posts - 37,396 through 37,410 (of 39,720 total)
-
RE: Cracking
Good point Brian,
Unless you leave your machine unlocked.
Keep in mind that the people you are concerned about in this situation are consultants or others who may wander in your office....
-
RE: Time out errors when Backup occurs
What version of SQL? Backup was substantially enhanced in 2000. Also, what type of backup?
It is possible with a large query or transaction that a backup could cause a timeout,...
-
RE: Perplexing User-Defined Scalar Function Problem
Is the user calling this as dbo.function?
Steve Jones
-
RE: Question
Or someone stole your server last night and EM can't find it.
Just kidding
Steve Jones
-
RE: Popular Column DEFAULT Definitions
I use:
dfZero - 0
dfOne - 1
others as needed (I have neede dfThree)
dfBlank - space(1)
dfGetDate - getdate()
dfGUID - newid()
Sequential - use identity or UDF
Random - use a UDF, will get better...
-
RE: login failure...
I think Brian has the best suggestions.
Though I would leave the BuiltIn/Adminstrators in there. Nice to have a second way in, just in case.
Steve Jones
-
RE: Table/Database Corruption
DBCC is your only real check. It sounds like you have data integrity issues, which are different than corruption. Can you search all the tables affected to be sure there...
-
RE: Pattern Searching with T-SQL
You are welcome. Glad I could help.
Steve Jones
-
RE: Cracking
I agree with brian, but if you ahve access to sniff. With today's switches being deployed in so many places, it can be difficult for someone in your org or...
-
RE: Fragmentation
For 10 extents, this cannot be a big deal. I wouldn't really be concerned unless I had over 100 extents.
Brian has good advice.
Steve Jones
-
RE: Need help with maintenance plans
If you get this, pls post it. We have mostly standard, but a few different ones and this would be nice.
Steve Jones
-
RE: ACCESS VIOLATION
This isn't a linked server issue from the sound of it, but a data or other client side issue (or server side i guess).
A couple other things (besides those listed...
-
RE: Transfer tables outside the firewall
You could query information_shema views and roll your own script.
Steve Jones
-
RE: User cannot delete
Check that he is not the member of some role that has access denied.
Also be sure the delete trigger is not preventing this.
Are there error messages?
Steve Jones
Viewing 15 posts - 37,396 through 37,410 (of 39,720 total)