• Create Information_Schema view

    Back in 2k, there was a backdoor that allowed you to create an INFORMATION_SCHEMA view. Backdoor yeilds a permissions error in 2k5. Is there any way to create a view in Master that would be accessabile from all databases like the Information_Schema views? Thanks for the help... --Jeff Moden

    Jeff Moden40 pointsBadges:
  • Hosting SSRS on Windows XP – user limitation.

    While I host SSRS on a Win XP Prof machine is there a limitation on the number of users who can access this site at once.

    Yup5 pointsBadges:
  • How can I restore my old data into the new design in SQL Server 2000

    The SQL Server 2000 application I was using was badly designed. Now that there has been a rework of my database design, so many more tables and columns are being added. How can I restore my old data into the new design?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using Case Statement Inside SQL Join

    Hi, I am trying to convert dynamic sql into static sql due to permission issue, I faced a challange when i am trying to convert this part of code given below -- join to ADDR_DETAIL SET @join_sql = 'inner join ADDR_DETAIL on ADDR_DETAIL.GRP_CONTACT_ID = pm.GRP_CONTACT_ID AND ' IF (@ChannelEntity =...

    Bmdayal5 pointsBadges:
  • How to transfer encrypted data between SQL Server 2005 and SQL Server 2000

    We are a retail/web/phone order store. We process credit cards for all three stores at our retail location. We have our web data stored offsite on the web server, using SQL Server 2005. We have our retail/phone order data stored onsite in SQL Server 2000. I'd like to add a function to our MS Access...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to execute the saved SSIS package.

    I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1 and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2. So I connected from server1 created a DTS package and...

    MNA20 pointsBadges:
  • How can I initialize arrays in stored procedures?

    How can I initialize arrays in stored procedures?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Decreasing CPU usage on SQL Server 2005

    My SQL Server 2005 is installed in Windows Server 2003. CPU usage is always 90-100%. If more users connect to this SQL server using their local Management Studio, then the server will become very slow. Can you please tell me how to decrease CPU usage on this SQL Server – is there a step-by-step...

    SQL Server Ask the Experts2,585 pointsBadges:
  • maxdop hint

    I have encountered the bug with MS and the processor issue with Mutlitple processors, the solution is to put the MAXDOP hint. SInce I have never used this and all the MS KB say to use it but not where and how, what is the proper syntax. ( I have a dual processor quad-core new dell)

    tcstl95 pointsBadges:
  • How SSIS works with cluster SQL and non cluster SSIS service?

    According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED. http://msdn2.microsoft.com/en-us/library/ms345193.aspx Now this is the situation that I have where I need to understand how SSIS works? Enviornment: Active Active cluster enviornment for SQL server with SSIS server...

    Munnu5 pointsBadges:
  • sql server errors………..

    hi I have 2 questtion: 1-After I installed the sql server 2005 enterprise on my server there isn't the sql management program in the program list of sql serevr 2005!!!!!!???? so I should installed the developer version of sql server 2005 on my winxp cleint and connect to server and work with sql...

    Aliyani265 pointsBadges:
  • Linking SQL Server databases to create DTS packages

    I want to create a DTS package in SQL Server for the following problem: 1. Table T1 in Database DB1 in server1. 2. Table T2 in Database DB2 in server2. 3. Table T3 in Database DB3 in server3. The DTS package will be created in DB3. I need to copy data from T1 and T2 based on T1.ID = T2.ID, from the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Do you have to break the replication after you install a service pack in SQL Server 2005?

    In SQL Server 2005 when you install a service pack - do you have to break the replication as you did in SQL Server 2000 - and then reestablish the replication?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Passing a database name as a stored procedure parameter

    I would like to be able to pass the name of a database as a parameter to a stored procedure. This db would be used for certain queries and may be different from the db where the stored procedure runs. Is it possible to specify a database name from within the T-SQL of the stored procedure? If so,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Merge Replication Identity Ranges

    What should the publication range and subscription range be set to for each table with identity ranges, bearing in mind thousands of changes can go into some tables each day. I have 1 Publisher and 9 Subscriptions (Merge) and have started getting "The Publisher failed to allocate a new set of...

    Ramapa25 pointsBadges:
  • C#.Net

    Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...

    Cmcwag0 pointsBadges:
  • execution plan is same even though it takes 10 times longer to run

    I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!

    Abbi20 pointsBadges:
  • Restoring a SQL Server 2005 IBM Rational RequisitePro database from SQL Server 2008, back to SQL Server 2005

    I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is it possible for named instances to share components in SQL Server 2005?

    Is it possible for two named instances to share components in SQL Server 2005? I’m aware multiple instances have their own components, but is there any way these can be shared to reduce overhead in SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I bring a .dat database file into SQL Server 2005?

    I need to bring a .dat database into SQL Server 2005. When I right click on database and Task, I don’t get the "Copy Database" option. What do I need to have this? What is an alternative method to bring the SQL Server 2000 database into SQL Server 2005 Express?

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.