Testing categories. Please ignore

Ignore this. It's a test for debugging purposes.

Char with null

SQL Server differences of char, nchar, varchar and nvarchar data types

Sherlee Dizon looks at the basic differences between char, nchar, varchar, and nvarchar, as well as what to be aware of when using each data type.

Generate script to change column length of string datatypes in a DB

This script can be used to generate alter column length of any string data type column(s) in a database.

RE: Prb: OLAP Linked Server from SQL Server

You're right re: the security.  On the slightly obscur side, when creating the connection (linked server) are/were there two different drivers for AS? (prob listed as OLE DB for OLAP 8.0 and 9.0).  I know with Excel connections, if you use the 'old" (sql server 7.0/OLAP services) driver, you can't connect to catalogs that contain […]

Rights to view\run jobs

What role or rights do I give a user to be able to see jobs in Enterprise Manager and run them? I just want to give the bare minimum rights for this.I'm using SQL 7 Thanks!

RE: QOD 17th Nov

Ok, I got it wrong !?!? too. But I will have to join the rest of this posters because "VERSIONING" is something way past that functionality. Can you get rid of just one "VERSION"? I can do that with ANY version-aware product, so I hope the above makes it clear that "Versioning" is not correct […]

RE: Cycling Those Error Logs

We use the sp_cycle_errorlog. We have not had issues with it. Scheduled tasks have been running for years.

RE: Backup to Disc - Corrupted files

quote: With this strategy I could potentially loose 11 hours worth of data if a FULL backup becomes corrupt. Any suggestions on how I can overcome this? What if I perform X-Log backups every 15min? Can I use X-Log backups to brigde the gap between the LAST KNOW GOOD FULL backup and DIFF and the […]