Forum Replies Created
Viewing 15 posts - 37,111 through 37,125 (of 39,461 total)
-
RE: Ansi Options Part 2 - ANSI_NULLS
Same here. I thought a short article might stick in people's minds and hopefully they won't have to research it themselves.
Thanks
Steve Jones
-
RE: Limiting object visibility
There is no way to prevent them as Anatares mentioned.
Steve Jones
-
RE: Backup Jobs hanging
Have you checked disk space? Any errors when the job hangs? It could be the file has grown and slowed the job and some other backup (tape) is interfering?
Can you...
-
RE: SQL AGENT Service doed not turn on
Check the event log or the sql server agent log.
Steve Jones
-
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 application mode. Perhaps install...
-
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
Viewing 15 posts - 37,111 through 37,125 (of 39,461 total)