-
Co-writing a book on Sql Server 2005 admin
I am co-writing another book on Sql Server 2005. This book will focus on administration. I’ve been busy with a lot of technical work lately, and will not post as often as before. Long time readers know that I co-wrote a book on Sql Server Integration Services. It has brought me fame from all over…
-
Using up and down arrow to cycle through sql command
Like osql, if you use up and down arrow, sqlcmd will cycle through sql statements you ran earlier. This can be handy. You can also invoke your editor for command editing, as I discussed here.
-
Renamed sa causing problem during replication distribution setup
In a previous post, I mentioned that it may be a good security practice to rename sa to something else. However, if you did that and later on decided to make the server a distributor in replication, you will get the error message below: Cannot find the principal ‘sa’, because it does not exist or…
-
Find out version number of Reporting Services
Here is how to find out the version number of Sql Server Reporting Services on your machine: Go to http://MyServerName/ReportServer. The version number is listed at the bottom of the page, like this: Microsoft SQL Server Reporting Services Version 8.00.1038.00
-
Sql Server aliases can be handy at times
In both Sql Server 2000 and Sql Server 2005, you can create server aliases on your client machine. When you connect to the database server from this client, you can use the server’s alias, instead of its real name. This can be handy at times. For example, if you have a DTS / SSIS package…