Viewing 15 posts - 1,666 through 1,680 (of 1,790 total)
I like jwiners solution in that the batch file ftp process is probably the way to go. I would then use a xp_cmdshell t-sql solution to rename the files. Example...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 28, 2001 at 7:21 am
Good place to start is
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/default.asp
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 27, 2001 at 9:09 am
I didn't really look at the ddl so, this is an off the cuff reply however, did you rebuild the index as part of the troubleshooting or is it being...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2001 at 1:30 pm
The web site to download is http://www.microsoft.com/data/download.htm#CCinfo
I wanted it too so, while I was there I thought I would make it easy for others to find.
Hope this helps and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2001 at 8:11 am
There is an OLE DB Provider for Exchange that is documented in BOL that is supposed to allow for connectivity and querying from SQL Server however, I have not tried...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2001 at 8:06 am
Start by bringing the Excel file into a temp table and then use T-SQL to pass it into the other tables. DTS will do a great job of bringing the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 18, 2001 at 11:19 am
Hence the problem with 3rd party backups. Another link in the chain that can break. SQL to disk is the way to go.
As Steven mentioned, he does not have...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 18, 2001 at 9:15 am
Anti-Virus on a server running SQL Server. Not here. Maybe I am a bit picky but, too much background munching by the AV software and really no benefit. I allow...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 18, 2001 at 7:09 am
"Wouldn't even say its a bad idea, but the opinions of most DBAs that have been working with SQL Server for some time is to backup to tape"
You mean disk...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2001 at 12:23 pm
Yes, you should be able to use a Full Database backup from Veritas to restore and restore subsequent SQL Log backups to it.
Two problems that I have seen really...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2001 at 11:12 am
You may also want to download the system table map - Books On Line - from the following;
http://www.microsoft.com/SQL/techinfo/productdoc/2000/systables.asp
I find this really useful in understanding how much of what goes...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 15, 2001 at 4:52 am
Um, Er, Well, after digging around a tiny bit during my 2 minute lunch, I did not find that you could do this within EM in 7.0. May be best...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 14, 2001 at 3:37 pm
Unfortunately no, you will have to restore the whole backup. However, you can restore to another place or another name and then copy the specific table back using DTS or...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 14, 2001 at 2:08 pm
I script everything. If I don't write the script initially (i.e someone else is developing) then I script following review. That way when I migrate to production I have everything...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2001 at 3:26 pm
In the EM Design View the Identity Col drop down select has "Yes (Not for replication)".
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2001 at 3:16 pm
Viewing 15 posts - 1,666 through 1,680 (of 1,790 total)