Posts tagged SQL Server 2008
Table information – column lengths, counts and unique counts
11 month ago
in Transact-SQL
Hi.
The Transact-SQL script below returns the following information:
ID – Just an identity column used within the script
SchemaName – The name of the schema
TableName – Obviously, the name of the table
ColumnName
Type – The data type of the column
Length – The maximum number of bytes used by the [...]
Transfer Logins and Passwords to a new server
01 year ago
If you need to transfer the logins and passwords from one server or instance to another server or instance, please refer to this very useful article from Microsoft:
How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008
Microsoft Certified IT Professional – Business Intelligence Developer 2008
02 years ago
As of Tuesday 1st September 2009, I have gained the Microsoft Certified IT Professional (MCITP) Business Intelligence Developer 2008 Certification. This is on top of my MCITP Database Administrator and MCITP Database Developer certification that I gained last year.
Save (Not Permitted) Dialog Box
02 years ago
in General
The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created.
The following actions might require a table to be re-created:
Adding a new column to the middle of the table
Dropping a [...]
Cannot Connect To SQL Server Analysis Services 2008
02 years ago
Whenever I tried to connect to Analysis Services using the SQL Server Management Studio 2008, I was getting the following error:
Cannot connect to [Computer Name]\[Instance Name].
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
No connection [...]
