I'm using Sql Server 2005 Management Studio on my client machine against Sql Server 2000 databases. For some reason, when I right-click to create a new diagram, the option isnt available. I havent run ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

Microsoft has been releasing newer versions of SQL with greater frequency, prompting DBAs to constantly ask themselves: “Is it time to upgrade?” Once that answer is yes, they have a lot of information ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More. This webcast will begin by covering some of today’s ...

The company I work at started very small but has been growing at a silly rate for the last few years now. They started with a server that was sharing a few other duties and also running the SQL DBs.