Clipmarks | greavesg's clips

Inspect Endpoints

Fri, 16 May 2008 08:15:09 GMT

clipped by: greavesg
clipper's remarks: Script to inspect endpoints

--------------------------------------------------------- -- ALL: inspect Endpoints --------------------------------------------------------- SELECT * FROM sys.database_mirroring_endpoints;

MS SQL maintenance scripts

Wed, 02 Apr 2008 17:04:34 GMT

clipped by: greavesg

Clip Source: blogs.x2line.com

```
DBCC SHRINKFILE(Pubs_log, 100)
```
```
BACKUP log Pubs WITH TRUNCATE_ONLY
```
```
DBCC SHRINKFILE(Pubs_log, 100)
```

SQL Scripts

Tue, 01 Apr 2008 13:37:04 GMT

clipped by: greavesg
clipper's remarks: Script to copy data into a file

Clip Source: www.experts-exchange.com

strExportSql= "SELECT final_rrp,final_fdp,deep_discount,title,time_stamp  INTO OUTFILE 'e:/exp.csv'" &_
                  " FIELDS TERMINATED BY ',' " &_
                  " LINES TERMINATED BY '\n' " &_        
                  " FROM f_data_today;"
 
     cnObj.Execute(strExportSql)