Answer Questions

• Sarang Datye Exporting SQL Maintenance Plans

  I have taken a look at the new maintenance plan designer and have come up with a maintenance plan I would like to be able to deploy on an enterprise level.  Anyone know of a way I can export the plan to another SQL 2005 server - without directly pulling from the msdb system tables   I like the fact that you can script the output of most of the wizards, but the maintenance plan wizard does not appear to be one of them. Thanks, Matt ...Show All

• Rajesh Kannan SQL Server Express SP1 Setup Changes

  The just released SP1 version of SQL Server Express has a file name of sqlexpr.exe. The previous setup file was named sqlexpr32.exe. Why would Microsoft change the file name Anyway, the file name change obviously breaks the file name that is coded in the bootstrapper package.xml file. Also, the link address will need to change (I suppose Microsoft couldn't just put a new version at the same link with the same file name so that everything wo ...Show All

• Damodarnet Parameter Mapping in an Execute SQL Task

  I am trying to assign the same package variable value to three different parameters in a query. The variable contains the name of a database which the user will input during package execution. First I check to see if the database exists (if it does I drop it), then in either case I create the database. See code: if exists ( select name from sys.databases where name =   ) begin drop databas ...Show All

• Jmoyano Schemas, Users, Logins, Database Roles, Application Roles

  Hello, I am new user of SQL Server. I have some problems with these words. I want to make my database works in my specified permissions. I will specify permissions with schemas and these schema wants an owner. I want this owner should be my user. When creating a user it needs a valid login. I am selecting my login and it occurs and error says this login has an different user. I am specifying permissions with roles. But i can't make associa ...Show All

• Amol Gogate Cannot get the Service Broker work

  Some months ago I was playing with Service Broker and everything was ok. But now I just can't get it work. I opened a sample "helloworld" project and still cannot get a message in a target queue. No errors, just empty queues. We have two SQL servers sept CTP on different computers and both give the same issue. It looks like it should have a very simple solution that I cannot come up with. The following script initializes service brok ...Show All

• MrT25 Divide by Zero Error

  I have a function that compiles a number of different aspects of a Select query and then creates some high-bred fields based on the result. The problem I have is that some of these values contain a zero or Null and therefore I am getting a divide by zero error. The three sums I have are as follows; Number 1:- SELECT........, fnWTRalldata . floortotocc / fnWTRalldata . floortotal AS floorspaceperc, BLAH BLAH FROM Number 2 :- SEL ...Show All

• cgraus Shrink log transaction file

  Good day, I have a database at the moment in SQL Server 2000 which is about 700meg, but the transaction log is just short of 50gig. How can I shrink this safely. Is setting the recovery model to simple and then truncating the log wise. Currently the recovery model is full. Please advise and help. I am trying to help my dad who manages a small office, with a SQL database, and I don't know much ...Show All

• Terence Leung Connection pooling not working in Clustered Env.

  Hi, We had deployed a .NET application in a non clustered environment with conection pooling and was working fine. Now we had moved to a clustered env and connection pooling stopped working. Is there any cluster aware setting that we need to look at. Please let me know your thoughts. Thanks in advance Can you be more specific on what went wrong Any error code, exception stack will be helpful. ...Show All

• kqjf SQL Impesonate Logon Problem

    Hi. I am currently working on an ASP.NET application which has to log on to SQL using a specific windows user account. As far as I am aware the only way to do this is by adding the Integrated Security=true ; property to the connection string. If you specify a user id and password then it will try to log you in as a SQL user. Is this all correct   To be able to login to the SQL server we explicitly call the LogonUse ...Show All

• johnny_no1_boy 64bit problem?

  I run SQL Server 2005 on a Windows 2003 64-bit server. I have created a package where I run an execute t-sql statement task. In the t-sql I have the following: select * from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="c:\test.mdb";User ID=Admin;Password=').pubs.dbo.data and I get the following error: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. But ope ...Show All

• Liebethal Page Header on 1st Page ONLY

  In Report Properties there are 2 entries each related to page headers and footers: one is to print them on the 1st page, and the other on the last page. I want my page header to appear only on the 1st page, but I'm getting it on every page. Is there any way to restrict it only to the 1st page I've tried using IIf to check for page 1 and surpress the contents of the page header and while it works, the space taken up by the header does not coll ...Show All

• froggy77 Interface not registered using Excel/mail?

  I am trying to mail an excel Spreadsheet using the E-mail icon. When I go to mail I get the error "Interface not registered" I gotta believe it's something simple I use Office 2003 You are posting this in a SQL Server Integration Services newsgroup. If you've never heard of it then maybe, just maybe, you're not in the right place. What do you think -Jamie Are you using SQL Server ...Show All

• zendic add entities to report model programmatically ?

  Hi Friends is it possible to add entities to a report model dynamically ,probably thru SOAP api we've c# app and we want to be able to add entities dynamically . Thanks for the help That looks like your best option. Thanks BOB. thats what i figured out finally. BUT i found a way of adding attributes to existing entities .am reading .smdl file using a c# program and adding a attribute under a specific entity. if i re-publish the mod ...Show All

• Limmer GetIsClustered() returns FALSE for Veritas Cluster Server

  With both SQL Server 2000 and SQL Server 2005 when running in a Veritas Cluster, the GetIsClustered() API returns FALSE. Does anyone know if this is working as designed Does GetIsClustered() really only mean MSCS clustered or should Veritas be setting that server property Thanks   Del Hoobler Posting the last email thread that we had on the topic.   From: Michiel Wories Sen ...Show All

• JJDIII Distinct Count in a new Measure Group

  Here is the situation: I have a cube that has transaction level data and there is a control number that goes with this data, but it isn't one for one.  If I have 60 million rows in the fact table, I have 50 million control numbers in a control number dimension. I would like to be able to slice the data by date (for instance) and then do a distinct count on the control number dimension.  I can do a distinct count w.o having to do ...Show All