Forum Replies Created
Viewing 15 posts - 5,896 through 5,910 (of 6,105 total)
-
RE: How to move tempdb?
There is a KnowledgeBase article on this very topic. Here you go:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
It has how to move any of the databases, whether user or system. For tempdb, basically it's as...
-
RE: SQL MAIL
Have you created a MAPI profile under the user account which the SQL Server Agent is running? If so, have you set the properties for SQL Server Agent to...
-
RE: DTS Java-application Package Execution
The key here, though, is that you have an app that runs in interactive mode. Anything that runs as a job shouldn't have any components that require user interaction... automated...
-
RE: AutoNumber Field?
Is Autonumber listed as one of your destination columns?
K. Brian Kelley
-
RE: sp_attach_db with multiple log files
Is your client willing to pay for the support call to Microsoft? I'm sure they've got something...
K. Brian Kelley
-
RE: Executing a string versus a static SQL Statement.
From a security perspective, you are probably okay. However, as I discussed earlier, if you want data manipulation to occur in certain defined ways that are strictly controlled (necessary...
-
RE: Executing a string versus a static SQL Statement.
I think the only cases I've implemented dynamic SQL is for sysadmin stored procs and the like. I too am paranoid when it comes to security. Just because...
-
RE: DTS PACKAGE WORKS ONLY IN MY LOCAL SERVER
What error are you receiving?
K. Brian Kelley
-
RE: Executing a string versus a static SQL Statement.
I try to avoid dynamic SQL whenever possible. Security is one issue, as I've already discussed (we have multi-user apps which have different levels of access) and the performance...
-
RE: sp_attach_db with multiple log files
Ouch. I'll keep looking. The bottom line, though gets back to:
quote:
the clients back-up strategy leaves a lot to be desired. -
RE: DTS Java-application Package Execution
When you are running through DTS Designer, you have an interactive session. Things like GUIs can be displayed. However, when you run as a job, there isn't an...
-
RE: Why did you decide to become a DBA/SQL Programmer?
I started coding professionally in QuickBasic 4.0 back in the 80s, writing doors for BBS and conversions for different BBS configuration files while still in high school. When I...
-
RE: ODBC DSN not Connecting
I've not seen it go to a different port, though that doesn't mean it didn't happen. Glad it was as simple as that!
K. Brian Kelley
-
RE: Executing a string versus a static SQL Statement.
From a security standpoint, I prefer static code. If I maintain ownership chains (for instance stored procs, views, and tables are all owned by dbo), I don't have to...
-
RE: sp_attach_db with multiple log files
I've never tried it, but what about the CREATE DATABASE using the FOR ATTACH option?
K. Brian Kelley
Viewing 15 posts - 5,896 through 5,910 (of 6,105 total)