Forum Replies Created
Viewing 15 posts - 36,616 through 36,630 (of 38,961 total)
-
RE: SSI Context
Tried reboots, client and server. Nothing seemed to work except changing the account back.
Researching the account now.
Steve Jones
-
RE: wrong query result
I'm not sure what you mean. Can you explain what the "report" is?
Steve Jones
-
RE: Backing up databases with a rotation basis
We do something similar to Andy. We keep between 1 and 4 backups on disk depending on the server (disk space and file size).
Makes it easy and quick to restore.
Steve...
-
RE: Restore backup without log file
When you restore from a backup, you do not restore the log. If you create a new database with a smaller log, you can restore into this.
Steve Jones
-
RE: Derived or Temp?
The biggest problem in this query is the functions in the subquery. They mean you won't be able to get indexes used for these columns. I'd bet you are getting...
-
RE: Can't View Tables nor DTS packages via EM
When you uninstalled and reinstalled, did you do this at the console or terminal session?
A few articles:
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q297064&
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q281460&
Was this an upgraded 2000 server? Haven't used this in...
-
RE: ASP, SQL and Windows Integrated Authentication
Most authors implement a worst practice to make things easier. A disservice to reads IMHO.
The SQL box will accept Windows Auth. Set up IIS for Basic and Windows auth, it...
-
RE: Adding a processor to an existing installation
Windows will not detect the processor until you upgrade the kernel to do so. This is not a trivial task and you need to be sure you have a good...
-
RE: SQL POP Quiz
My vote is for crappy programming!
Must have been a developer, not a DBA
Steve Jones
-
RE: read-only tables
Check the triggers.
Not sure you can mark a table read only. I think you can a filegroup. Or a database
Steve Jones
-
RE: Using UPDATE ?
You are welcome. Keep coming back.
Steve Jones
-
RE: Query Analyzer not working
Can you manually type in the name\instance?
Steve Jones
-
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...
Viewing 15 posts - 36,616 through 36,630 (of 38,961 total)