Viewing 15 posts - 4,246 through 4,260 (of 7,429 total)
quote:
My initials are sp.Sean P
quote:
I use my initials on stored procedures and require that...
November 19, 2002 at 5:06 am
Yes, deffinmently use the backup restore method. 192Gb will take quite a while and has many factors that affect the time.
November 18, 2002 at 6:24 pm
When you say dwnload, exactly what type of connection and what transfer method. IP thru HTTP or FTP, IP thru share, which type? Any pretty much can be done but...
November 18, 2002 at 4:12 am
Generally no, locks prevent other activity from occurring against a referenced table until the process issuing the lock is complete. If a timeout occurrs of a process is deadlock and...
November 18, 2002 at 4:08 am
I do agree it is a security risk but if a person can get to the file your security is an issue. Most likely the average person won't even know...
November 16, 2002 at 5:39 pm
The easiest way is to use xp_cmdshell in yuor SP. However launching your app is designed to write it's responses back to the cmd shell it may be created and...
November 16, 2002 at 5:24 pm
Has nothing to do with the extension. You can open anyfile in notepad no matter the extension. However I believe you concern is the fact the data is not encrypted...
November 16, 2002 at 11:11 am
No keep in mind we are talking about the first three characters being sp_ doesn't matter what is after it. In you situation all procedures with sp__ still fall prey...
November 16, 2002 at 9:45 am
That is probably the answer, I will check on this later.
November 15, 2002 at 11:05 am
I do believe that is correct. Might check with profiler just to be sure. I may when I get a chance.
November 15, 2002 at 8:39 am
How to setup merge replication between SQL Server 7.0/2000 and Jet (Access 2000) subscribers?
Here are the steps you should follow to setup merge replication from SQL Server to Jet subscribers:...
November 15, 2002 at 6:13 am
Paul I do agree with you on the point of don't use sp_. That was the orignal statement.
The thing here was to try and understand under the hood why...
November 15, 2002 at 5:00 am
What country is this for and will this need to be available to all users? If so then what version of SQL Server are you running? The key will be...
November 15, 2002 at 4:42 am
I have not come across this before. Did the server start back up or fail. If started then may be there just not visible. Check the path of all the...
November 15, 2002 at 4:30 am
Viewing 15 posts - 4,246 through 4,260 (of 7,429 total)