What about creating "staging" tables that you grant Windows groups to and then have jobs run that actually perform the requests.. This way you can manage the security and the job can get done. Also, this would help set you up for the future to switch to sp's because the groups would already be in […]
2004-01-02
1 reads
You cannot restore a SQL Server backup to MySQL. You can possibly use DTS or other facilities to transfer data though.
2003-07-21
1 reads
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
I want to know where the script that take the Db and copy it to another partition ?? and is it possible to copy DB get out of Database maintainace planner (that output data with specific names formats, including time and date)?? Alamir Mohamed Alamir_mohamed@yahoo.com
2003-07-01
1 reads
We have a 60+GB database with near 24x7 availability. We have a very short 5 minute window between 9:25 and 9:30 pm where we want to have a "snapshot" backup of the database that represents the start of nightly batch processing. We accomplish that with the following approach: At 8:00 : Backup Log <database> WITH […]
2003-06-27
1 reads
We use a variation of #2. We backup to disk, then copy to disk on another server. Then these are both backed up to tape. The reason we copy to the second server is our tapes are off-site and if the original server dies, we can pull the backups off the second server we copied […]
2003-06-27
1 reads
Date time as expressed by BOL quote: Values with the datetime data type are stored internally by Microsoft SQL Server as two 4-byte integers. The first 4 bytes store the number of days before or after the base date, January 1, 1900. The base date is the system reference date. Values for datetime earlier than […]
2003-06-26
1 reads
Try this select MIN (intID),vchrCode,vchrDescription,lngValue from TableName group by vchrCode,vchrdescription,lngvalue HAVING COUNT(vchrCode)=1
2003-06-26
Hi jimmYLepp, quote: Does anybody have know of a good tool to log to a SQL Server database from unix? We used to use sybases isql but that doesn't work with SQL Server 2000. LINUX comes along with unixODBC. Have a look at http://www.unixodbc.org Cheers, Frank
2003-06-26
Haven't tried, but it should work as long as you have rights to use xp_cmdshell. Syntax should be xp_cmdshell 'wscript whatever.vbs', I think. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-25
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers