Tag: sql-server-2005

Sql Server 2005 Analysis Service -cannot connect to sql browser

This is my first attempt at using Business Intelligence development studio. I have set up the project and now trying to deploy my changes. When I run the project I get an error ensure that sql browser is running. Done- setting up cubes & mining structure. Checked that database instance is correct. I have checked […]

How to store certain number of backups in backup file

I have everyday schedule to backup my database in sqlserver 2005. Now it’s looks like this: BACKUP DATABASE [db1] TO DISK = N’D:\SqlServer\Backup\db1.bak’ WITH NOINIT , NOUNLOAD , NAME = N’db1backup’, NOSKIP , STATS = 10, NOFORMAT But in this case, it’s will grow infinitely and I want to store only last 7 backups in […]

Displaying totals within a specified date range in Microsoft Access

Although I have experience with SQL and generating HTML reports with PHP, I’m a relative beginner with Microsoft Access. I’m currently using Microsoft Access 2007 to connect to MSSQL Server 2005. I have a table of Reports that looks something like this: ReportID DateCreated Author … I’d like to create a form that allows the […]

SQL Server: inline conditional convert with XML?

I need to convert data in plain text columns into xml columns. However, not all of the content is valid XML, so I need to ignore any rows with invalid XML. Is there a way I can filter out the invalid data either using some sort of inline conditional convert or something in the WHERE […]

Obtaining the Following Error in SQL Server 2005 <The server principal “XYuser” is not able to access the database “Ydb” under the current security context.>

System Specifications… Microsoft SQL Server Management Studio 9.00.4035.00 Microsoft Analysis Services Client Tools 2005.090.4035.00 Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 7.0.5730.13 Microsoft .NET Framework 2.0.50727.1433 Operating System 5.1.2600 On an SQL Server 2005 called BHAVMSQL02, I have two databases Mattercentre_dev and CMSNET_DEV. The Mattercentre_dev […]

What is the difference between SET xact_abort ON and try/catch block with Transaction handling in sqlserver 2005?

I need to improve some existing stored procedures in my project for better transaction handling. I understand I can use the SET XACT_Abort ON statement in my procedure so that transaction will be automatically rolled back in case of errors. I can also use Try/Catch block for error handling and roll back the transaction in […]

Is there a dynamic management view in SQL Server 2005 that pertains to column statistics?

The dynamic management views of SQL Server 2005 can give usage information about table indexes. Is there a similar method for getting usage information about column statistics? In specific, I’m curious if some of the older column statistics I’ve created are still being used. If not, I’d like to delete them.

Schema binding for a UDF using tables from other db

I have a UDF in SQL 2005 that I would need to schemabind as it is used in a view that I need an index on. This UDF gets information from a table that is located in a different db (same server) then the one where the UDF is located. Since it is invalid to […]

tsql- to find when was the database taken offline

Is there a way how we can know when was a database taken offline? Platform: SQL server 2005

Hooking up Reporting Services 2005SP2 to SQL Server 2008

I am trying to configure Reporting Services 2005SP2 on a machine with SQL 2008 on another hosting the ReportServer DB. When I create the ReportServerDB the DB is created as version C.0.9.45: When, afterwards, I try to initialise Reporting Services, I get an error about an incorrect version number. Reporting Services created a ReportServer DB […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.