Forum Replies Created
Viewing 15 posts - 37,921 through 37,935 (of 39,496 total)
-
RE: Calculating a median in SQL Server
Thought this would work, but the table datatype (from bol)
table
A special data type used to store a result set for later processing. The table data type can be used...
-
RE: start operating system command when new inserts
you will have to be careful about permissions and for that reason I would not do it, but yes, you can
create trigger mytrigger on mytable for insert
as
exec master..xp_cmdshell 'dir c:'
Steve...
-
RE: using SHAPE language in a stored procedure
you'd do a join.
select *
from staff s
inner join
staff_pub_link sp
on s.staffid = sp.staffid
Steve Jones
-
RE: Upgrading server question
Should be. The only thing that is bound to the old box is the sid, so if you had some service that relied on an ACL, you might have issues....
-
RE: Why need Sql 7 client Config Utility?
You should be abl to just connect using whatever method you want and giving the server name. The default might be for clients to use Named Pipes, but other than...
-
RE: Reports
I'd vote log shipping, but honestly don't like either one.
Let me clarify with Replication is more mature and probably more stable. If you have an issue, it might be a...
-
RE: Reports
Easiest? Backup/Restore.
Need more real time, then replication may be best.
Steve Jones
-
RE: Upgrading server question
If your clients connect by IP, then yes. Most clients connect using DNS/Wins/NetBIOS, so you may not need to.
Steve Jones
-
RE: Upgrading server question
If your clients connect by IP, then yes. Most clients connect using DNS/Wins/NetBIOS, so you may not need to.
Steve Jones
-
RE: Linked Server ODBC
Strange. I don't have a good answer, but are you positive the old dev box and the prod box are setup the same? No "test" things done to the dev...
-
RE: MS DOS char set
Can you give an example? It may be that there are carriage returns that are causing formatting issues in QA.
Steve Jones
-
RE: DB creation
Tend to agree with Andy, though I'd add that you would want a separate physical device for the ldf.
Steve Jones
-
RE: start operating system command when new inserts
A couple solutions:
1. Insert a value in a table using a trigger. Run a DTS package every 10 sec, check for new values and run the command
2. Use master..xp_cmdshell. It...
Viewing 15 posts - 37,921 through 37,935 (of 39,496 total)