Forum Replies Created
Viewing 15 posts - 37,186 through 37,200 (of 39,520 total)
-
RE: SQL 65 Device Resize
not in v6.5. Need to bcp out, recreate, bcp in.
Steve Jones
-
RE: job hunting
It will depend on you, where you are, and the company.
My experience is that companies ask for the ideal, but rarely get it. Probably changing in this economy with lots...
-
RE: I need opinions from you on which db to choose...
SQL Server will be windows license + $5k per processor to run on the Internet. Unless you have all authenticated users, then you can use CALs, but that probably won't...
-
RE: Cleaning up duplicates
Sounds like a few scripts:
For phones,
select phone, count(*)
from vendor
group by phone
having count(*) > 1
Steve Jones
-
RE: Sa password missing
If you can connect with NT, you can snag the passwords and get them. See the "cracking thread" in this forum.
Steve Jones
-
RE: data encryption
Just a note here. If you don't encrypt at the client, then the DBA can snag it with Profiler anyway. Sort of defeats the purpose.
Steve Jones
-
RE: inactive processes
No way I know of. I wrote a script that would check the last batch time and use exec() to kill the spid.
Steve Jones
-
RE: Check for Zip file to process DTS job
The FileSystemObject has a "fileexists" property you can check.
Steve Jones
-
RE: Cracking
And typical. People laugh at me, but I never leave a consultant alone. Some junior admins have gotten annoyed because I've had them babysit someone while I had to do...
-
RE: Perplexing User-Defined Scalar Function Problem
That's possible. Apologies, but I'm not an Access person. Hopefully Andy or someone else will chime in.
Steve Jones
-
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...
Viewing 15 posts - 37,186 through 37,200 (of 39,520 total)