RE: Backup To Multiple Devices
RESTORE database <dbname> FROM device1, device2,device3, device4, device5
2003-07-21
Foreign Keys (FK)
RE: Need a little course in ASP
Hi Crispin, quote: Easiest way: Set a cookie containing the time when the page finishes loading. On the next page (or same one) attemp to retrieve the cookie and get the time. Start - new start = (you get the idea) 🙂 Your only problem will be the last page the persons sees. You can […]
2003-07-14
RE: Log Reader agent fails
I have no idea but, I'm dying to see the resolution. please continue to post your findings.
2003-07-09
1 reads
RE: Backup Debate...
We use SQL Litespeed for all our SQL servers, then we back these backups to disk. It's cheap and heaps faster than native SQL backups. It shrunk our 30 gig database down to 3 gig and it's encrypted. Not to mention it's another great Australian product! 🙂
2003-07-08
1 reads
RE: Preventing MSAccess Connections
Ok, why unfettered Access, access to a SQL Server database for users unless they really know what they are doing. Two words: Table Lock It is really, really easy for someone to run a query that is really really stupid. They qualify on just a non-indexed field, use a function, etc against a big table […]
2003-07-08
1 reads
RE: Moving entire SQL content to new server.
It sounds to me like you are trying to clone a server. I think the quickest, easiest way to migrate the whole server is to do the following: This is assuming that the new server has all the same drive letters/paths as the old one. Stop the SQL Server Service on both machines. Copy all […]
2003-07-08
RE: How to initiate COM....
If you talking about a proc querying two servers, yes. I would lie to you if I told you how etc. Linked servers is not my strong point. There will be somone else here who could help you. Cheers, Crispin
2003-07-03
RE: EXport to DbaseIV fail with truncated file name ?
Check that something hasn't changed on the file system. Can you write to a different file? Different folder? Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-07-02
RE: Multi Row Insert?
insert into tblCustPreference( custguid, name, ) SELECT x.custguid, x.name, FROM OPENXML (@xdoc, '*/cust/coldata',1) WITH ( custguid uniqueidentifier, name varchar(25), ) as x
2003-06-28
RE: Local system account vs Domain user
Executive is nothing but SQLServerAgent. If you are using distributed transactions (Calling the remote stored procs on some other SQL Server and Distributed updates) in your application you might want to start the DTC with same service account. Yes you must restart the SQL Service to take place this change not the Windows
2003-06-27
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers