Featured Articles

• Get And Set SQL Server 2005 Instance Registry Values
• SQL Server Password Management:
• RSS Newsfeed Workbench
• Migrating Data Warehouse Systems to SQL Server 2005 (One Year Ago)

Editorial

• The July Car Update

Featured Script

• Finding other database objects referenced in an SP

Users That Need Help

• SQL Server 2005
• SQL Server 7,2000
• Career
• Programming
• SQLServerCentral.com
• Reporting Services
• Data Warehousing
• Third Party Products
• Microsoft Access
• Article Discussions

Get And Set SQL Server 2005 Instance Registry Values

Vince Iacoboni from SQLServerCentral.com

Most SQL Server DBAs will never need to read the registry for their instances, however in case you do find yourself needing to read or write something in SQL Server 2005, Vince Iacoboni brings us a technique for performing both of these actions. More »

SQL Server Password Management:

Additional Articles from SearchSQLServer

Improving SQL Server password management includes thorough password testing and securing SQL Server installations beyond the main database server.More »

RSS Newsfeed Workbench

Additional Articles from SimpleTalk

Robyn and Phil decide to build an RSS newsfeed in TSQL, using the power of SQL Server's XML. More »

One Year Ago - Migrating Data Warehouse Systems to SQL Server 2005

Vincent Rainardi from SQLServerCentral.com ( published: 07/31/2006)

As many of you know I like cars. In fact, driving my car around Denver to get to baseball games is almost as much fun as playing. So this month I went to the UK, really just Cambridge, to visit Red Gate and of course I paid attention to the cars that I saw.

First observation: They drive on the wrong side of the road. Not only that, but the steering wheel is on the wrong side. Of course the transmission shifts in the appropriate way and it seems like the controls are the same as they are in the US, just shifted a few feet to the right.

Second Observation: Cars are small. Most of the cars are smaller coupes or sedans, but even a 5 passenger sedan seems slightly smaller than it might otherwise be in the US.

Third Observation: It's a good things cars are small because roads are smaller. So small in fact that I found myself cringing as we passed through traffic in the city. People tend to drive up on curves or fit next to busses in ways that I am very much not used to. I've driven in New York traffic and this is much crazier in my mind.

But despite the chaos, it seems most drivers respect the tremendous amount of cyclists and I didn't see any accidents during my week there in the city. I also saw lots of diesels, which is nice to see. I think the US could do better if they produced more diesels, especially some of the newer, cleaner, more efficient models.

I was glad to get back into the US and drive my own cars around on the correct side of the road. It was also a time for maintenance on the cars and the first oil change for the Prius. I took some time to calculate out the costs of the car compared with our old minivan. To date, with conservative numbers, I've used 150 less gallons of fuel and saved $450. That's across 5000 miles and a little over three months. Using what I suspect are better numbers, 53mpg for the Prius, 18 for the minivan and $3.10 a gallon, we're more like 183 gallons and $568. With the $1500 tax credit, I think I've paid back half of the "hybrid premium" so far. For me, it was a good investment and it's saving some fuel.

Lastly, if you do happen to live in Germany and want to get a cool job, Porsche is holding an open call for positions, including people that can help them build vehicle-communication technology. Women especially are encouraged employ. When I was a young, unattached, ignorant high school student, my ideal plan was to get my college degree, start my MBA and take a year abroad working for Porsche, get the latest 911 from them, and then go spend a year or so in Japan working for Sony and load up on their gear.

Life has certainly changed!

Steve Jones

» Join the debate, and respond to today's editorial on the forums

» To submit a tip, rant or editorial, email articles@sqlservercentral.com.

Today's Question:

What causes a deferred transaction?

Think you know the answer? Click Here, and find out if you are right.

This Question is worth 2 Point(s) in this category : Design and Theory. We keep track of your score to give you bragging rights against your peers. If you have problems with submitting you can go to the QOD section inside the Test Center directly at http://www.sqlservercentral.com/testcenter/QOD.asp

We'd love to give you credit for your own question and answer. To submit a QOD, simply send the question, answers and explanation to articles@sqlservercentral.com

You want to create an SMO program that will restore your nightly backup to a new database on the same server that can be used to check on data changes by the support department. What do you need to do in addition to run the RestoreDB method?

Answer: Add an instance of the RelocateFile class for each file to the RelocateFiles collection.

Explanation: Since this will be on the same server, you need to move the files to new locations and/or use new file names. This requires you to add the RelocateFile class to your RelocateFiles collection.

Ref: SQL Server Management Objects (MSDN) - http://msdn.microsoft.com/msdnmag/issues/07/06/DataPoints/default.aspx
RelocateFile Class - http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.relocatefile.aspx

Here's a few of the new posts today on the forums. To see more, select Discussion Forums in the Community menu on the site:

   moving log file of user database - Hello,           I need to move a 30gb database log file from one drive to another as it is created on a wrong drive.i used the detach attach method.but when i try to cop....(more online)

   2000 to 2005: Upgrade or Migrate ? - Initially, the articles I read suggested that doing an "in place" upgrade is the simplest path, with the drawback that if something goes wrong, I'll have to re-install 2000.  And that migrating is more difficult since I'....(more online)

   Database Mail Configuration - Does Database Mail work with MX Records? Has anyone put in a solution on SQL 2000 and SQL 2005 using MC records? Any suggestions you can provide would be greatly appreciated.TIA.......(more online)

   Next run date and time - not updated - I am having a strang e problem in Sql 2005 Enterprise RTM with the job scheduler. Whenever I make a change to my schedule (enable or disable schedule, change frequency, time etc), the next run date and next run time (in ....(more online)

   Sql Server 2005 Express Edition -- Memory Error - Hi Friends, I am getting this error in sql server 2005 express edition.Error:The instruction at "0x6c39b103" referenced memory at "0x00000001". The memory could not be "read".   Front end application is written....(more online)

   backup error - Hi ,when i am restoring the diff backup i got this error.can u help me most urgentMicrosoft SQL-DMO(ODBC SQLState:42000)The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequ....(more online)

   backup going forever - Hi,i started a full database backup job for a very large Database around 500 GB. When I go to SQL management- JObs and If I refresh over there I still see the status of the job is still executing. It has been more than 24 hou....(more online)

   Backup all databases - Hi, am using this script to backup all databases.But now i want it to overwrite the previus databas and not incremental backup.DECLARE @name VARCHAR(50)DECLARE @path VARCHAR(256)  DECLARE @fileName VARCHAR(256)  DEC....(more online)

   Cannot retrieve row from page (1:2108289) by RID -  MigrationData is my production database last few days i got the error message when i execute a procedure on this database, although i have installed new service pack 4 for sql server 2000.also i have recreated a new dat....(more online)

   repetition of records - Have application writing data in SQL 2005 database from a datasourceneed to maintain only unique records in the database table.No. of times the original datasource gives duplicate records which get inserted in the databa....(more online)

   Reporting services, Stored Procedures, "Nested" tables - I was given a task to convert existing reports from classical ASP.NET into Reporting Services. One report actually contains data from three different tables:ORDER_HEADER order_id | customer_name |  order_date1 ....(more online)

   how to join two tables from different servers - hi!i m trying to join two tables in different databases from different machines on LAN. i couldn't get it. i m using sql 2005.it was ok to join two tables of different databases on lacal machine.can anyone help me ?....(more online)

   Issue while running upgrade advisor on remote server -  Hi, While connecting remote SQL server through upgrade advisor I am getting the below errors:Error: Unable to connect to server. Reason: An error has occurred while establishing a connection to the server.  When co....(more online)

   Reseed doesn''t change column properties? - I have a table with an Identity column (1,1).  I find out from the business unit that they don't want the identity fields to start with 1, they want to start out with 100,000,000.  Okay, so I run the DBCC command to....(more online)

   Package Storage - MSDB via File System - HiI'm wondering how people have chosen to store their SSIS packages - file system or in msdb? From what I've found it seems that both methods work well. File system seems to be slightly easier for editing and changing package....(more online)

   dynamically assigning file name as an mail attachment - Hi all, Can you please send me code sample to dynamically assign file name - which I have to send as mail attachment. vcFilePath is the variable declared in SSIS which store network pathvcFileName is the variable declare....(more online)

   Script Task - SSIS - Hi,I dont wish to use a data flow task just to use the conditional split...Instead I want to form a script in the control flow which will disable/enable tasks accordinging to what the variable is set when an sql task is execu....(more online)

   How to skip the first row in an excel workbook - Hi All,        I have a excel workbook with many sheets, in each sheet the first row has to be skipped and the second row contains the column information and thereafter are the records.The E....(more online)

   help for table scan - I have a problem with a query that performs full table scans on SLQ server 2005 standard/Win 2003 Server, 64b. The same query behaves differently on the same schema on SQL server 2000 ? no FTS. This I strange to me because mo....(more online)

   query has different execution plans on different servers - friday we noticed a poor running query with an index scan instead of an index seek. Friday night i dropped and recreated the index and it ran OK afterwards.on saturday we ran update statistics with full scan on the entire dat....(more online)

   Using bit flags in large tables - We have a table with about 2 million rows. The rows are flagged as being active or inactive using an "IsActive" (bit) flag.Most queries against this table will need to include a "WHERE IsActive = 1" to ensure we only return t....(more online)

   Hardware & RAID Configuration - What''s the best - Hi,I'm about to setup a new production enviroment which relies heavily on SQL Server 2005 Enterprise to manage a processing queue. There will be lots of BLOB data in a form of XML exchanges (a separated file was designed for ....(more online)

   query spiking CPU to 100% - upgraded one of our servers to sql 2005 SP1 a week ago and we have been troubleshooting performance problems ever since. so far we have narrowed it down to 2 queries. this one spikes our 8 900MHz CPU Compaq server to 100% for....(more online)

   Kerberos setup on windows 64-bit - Anyone has experience setting up kerberos authentication on SQL Server 2005 on Windows 64 bit?  It is working for me on windows 32-bit.  I didn't need to do anything, but to make sure the sever and client are on the....(more online)

   List Server Roles - I am currently working on a SSIS configuration database.  However, I am having trouble writing a script to get the the users that have each server role permissions.  I'm pretty sure that I need to use sp_helpsrvrole....(more online)

   accessing sql server with proxy - HelloI am trying to acces a remote db , but there is a proxy on my network, and i get an error that remote access is not allowed. (i can't even ping the server)The dba said all ports are open, so what could be the issue? know....(more online)

   SP_ADDALIAS vs CREATE USER - Hi,I am new to SQL Server 2K5.Quick question...What is the exact equivalent of:SP_ADDALIAS user1, DBOIn SQL Server 2K5 (CREATE USER)Many thanks in advance. ....(more online)

   Case-sensitivity of login names - Hello there,I am wondering, why SQL Server 2005 (9.0.3042) behaves differently on two separate installations.On both machines I have defined logins, which have upper-case names ("TESTLOGIN"). I can connect to the databases us....(more online)

   BEST PRACTICE ON PRIMARY KEYS - I have to use primary keys but they seem to be a bit lenghty.However they all provide meaningful Identification especially at the database level.They are not friendly especially on application side in searching,retrieving rec....(more online)

   DEPLOYING A WEB HOSTED SQL SERVER 2005 - I am planning to deploy my web based application on a web hosted SQL Server 2005 Standard Edition,as well as an Apache Webserver .Both will be in the two separate boxes running Windows 2003 .As I am new in the web based syst....(more online)

   Write a Simple Query... if u can. - HI ALL! Please Look at this Table:-----------------------------------------ID      NAME  YN------------------------------------------1        A &....(more online)

   Benefits to using the Identity column - I'm designing a database and was researching common conventions and standards. I found that some people don't use the identity column for a primary key because they prefer to create their own unique id number for the column. ....(more online)

   -2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation - I Have SQL Express installed on 17 ships. Each ship has a VB6 Client application using OLEDB to connect to the database on local machine. Other workstations on network also connect - we think without error. The error abo....(more online)

   Where is SubscriptionStreams parameter shown? - Trying to take advantage of SS 2005 Replication parallelism.  I set up my publication with the option: @SubscriptionStreams = 4... here is the script to do so:exec sp_addsubscription @publication = N'MySubscription', @su....(more online)

   Performace Issue with replication on Sql 2005 - I have a client that we have set both merge and transactional replication between two sites both running Sql server 2005. We are getting connectivity errors for about a 1 minute duration on an hourly basis.I have checked perf....(more online)

   how to get the number of rows exported through bcp - Hi,I need to be able to output the number of rows exported through bcp to another file.  Is there a simple way to do this?The current code is as follows:DECLARE @sql varchar(8000)SELECT @sql = 'bcp "exec stored procedure....(more online)

   help with dynamic SQL - I have what 'should' be an easy query but its stumping me so I'm guessing I'm overlooking something simple. I have a data model for Users, Products, Orders and OrderItems (in other words, a User can place one to many orders, ....(more online)

   TSQL Create Network Share - I am trying to create a network share using TSQL (for the purpose of scripting the installation of Mirroring).I have come up with the following script/* ==================Map Network Drives==================*/declare @bkupdir....(more online)

   How to horizontally show columns record with group by (Challengin SQL Query To Write,At Least For Me))? - Table A:ColAColBAJohnABillBHenryCKeithCLukeCPeterTable B:ColAColBAJohn, BillBHenryCKeith, Luke, PeterI wan to write a query (without looping/cursor if possible) that can extract data from Table A and return resultset as ....(more online)

   I need some help.... I cannot execute any query from sql 2005. - Hi all,I need some help.... I cannot execute any query from sql 2005, when I try to execute a query it stays executing and I never receive any result set.   I uninstalled and re installed again SQL 2005 in my comput....(more online)

   File sizes : single 145G file how do I get it into 5-10gig files - Are there any other utilities to export the data, shink the files, create new files and re-import it?BCP keeps erroring out based on time-out and once because of memory.  I am trying to make smaller, more manageble files....(more online)

   How to identify a failover event ... - Guys,We have active/passive cluster set up.  There are 2 machines in a cluster.  If machine 1 fails, machine 2 takes over, with no fail back.We had an issue recently - there was a failover, but we never knew about i....(more online)

   Snapshots - Does anyone know how to restore a snapshot of a database to another server, and then apply transaction log backups to the new database? ....(more online)

   DBCC shrinkfile error - Msg 8985 - HiI am getting following error when I try to shrink the transaction log:DBCC SHRINKFILE (wslogdb50_Log, 2000)Server: Msg 8985, Level 16, State 1, Line 1Could not locate file 'wslogdb50_Log' in sysfiles.DBCC execution complete....(more online)

   CHECKING DATABASE PERFORMANCE - Hi, We have a higher end database server that is accessed by the users using front end developed in Visual Basic 6.0. Also there is an application developed in .Net accessing another two databases from the same server.&n....(more online)

   Large Transaction log Backup failing with OS error 33 - We have a SQL 2K DB running on Win 2K that is about 45GB the DB is in Bulk-Logging mode. We have started running some jobs that cause the Transaction log to grow quite large 20-30GB.  We have started seeing some problems....(more online)

   Transaction log backup (DB in simple mode) - Can transactions for a DB in simple mode be backed up? Thanks,-R....(more online)

   SUSPECT database -  Hi, My laptop hanged as I was running a large table update and when I restarted my database was marked as 'SUSPECT'.Running sp_resetstatus @dbname = "mydb" says that the flag has allready been reset but does not make an....(more online)

   not recognize database - Dear all, this morning suddenly i got suspect problem with my database. Suddenly, my database: ReportASM turned into suspect mode. So, i try to restart the services. After that, Enterprise Manager not even recognize ReportASM....(more online)

   Releasing Memory captured by sp_xml_preparedocument - We are experiencing memory problems using sp_xml_preparedocument. The errors areWARNING: Failed to reserve contiguous memory of Size= 13631488andInsufficient memory available. Investigation shows several stored procedure....(more online)

   Querying the max row length - Hello everybody,I just started at a new customer site and discovered that they have lots of tables the the theoretical total lentgh of a record can be over 8060 bytes. Some tables have up to 8 nvarchar(2000) columns. So far t....(more online)

   Confused by article in sqlservercentra.com ? - Hi, I m little bit of confused in an article in sqlservercentra.com at this link:http://www.sql-server-performance.com/performance_monitor_counters_sql_server.aspWhich says :If you find out that the number of page splits is h....(more online)

   Looping steps in DTS - 2 steps waiting causes error - I keep getting an error since I am setting two steps waiting (one the active task i'm on and the other the one i have to back to in the loop).  How do I loop back to task 3 and keep the task i'm on waiting?Thanksmathjon*....(more online)

   Rank Sequence by Group - I know this can be done in SQL 2005 using PARTITION and OVER but I need to do this in SQL 2000. Here goes...I have a table as follows;Jobno decimal(6,0)Status char(2)Date datetimeJob    Status  Date 1....(more online)

   Import Slow - We have been experiencing extreme latency when running DTS packages importing information from an Oracle database into our SQL database.  The network gurus have been checking routers, switches, bandwidth etc. and have fo....(more online)

   Performing Tuning Reference - Can anyone recommend a really good book on performance tuning SQL Server.  In addition to being thorough and easy to understand for an experienced DB analyst but novice DB administrator the ideal book would cover bo....(more online)

   blocked waittime - MS KB article 906344, discussing latch waits states that "most of the time you can ignore the value in the blocked column if the following conditions are true:. The value in the waittime column is low"In the above context, wh....(more online)

   SQL 2000 using profiler for disk reads tuning -  We have a large db with a ton of online queries running. We have been looking at the SQL statements for index tuning already. What I want to know is how to use profiler to see if there is i/o disk bottle neck. I have do....(more online)

   setup kerberos authentication for SQL Server 2000 - Hi,I need some help to setup Kerberos Authentication for SQL Server 2000.  I believe by default Window authentication in SQL Server is Kerberos.  But I don't know enough and have not come across any documentation th....(more online)

   login management - Im using SQLServer 2000 sp3a (old I know) and I'm new to my DBA job. One thing I've noticed it that domain logins accounts still show up as active in enterprise manager even though they are disabled or deleted in Active ....(more online)

   Database Security - Hi,Our Development team have all recently acquired laptops and of course the first thing each member wanted was to install a local SQL Server onto it with our Corporate Database to be able to do local Development.Can anyone r....(more online)

   connecting SQL Server 2000 to Oracle 10g RAC - Guys, is it possible to connecting SQL Server 2000 to Oracle 10g RAC?I've tried, but it was failed. The error message was: error 7399 or unexpected error.Usually, I connect SQL sever 2000 to Oracle 9i. Every day, my server co....(more online)

   BCP Bulk insert from an excel file - Hi,Is it possible to bulk insert from an excel file (after converting it into a txt file).I tried it but could not succeed, can anyone suggest some way for it....(more online)

   Is it considered good practice to have one database file per cpu? - CPU (I didn't know there was a length limit for subjects!)I came across this blog entry from a (former?) Microsoftie who suggests that it is a good practice to have one database file per CPU, so on my quad boxes, I should hav....(more online)

   Data mining - I'm starting the developpement of a brand new version of an in-house application. One feature that would be incredibally usefull for the users is to be able to have a way to question the system.  For example : From ....(more online)

   Foreign keys - How can i check if my database has any circular references/relationships and how to get rid of them.....(more online)

   Create table with cursor data as columns - Hi all, Here i have one question thatI am  fetching some names through the cursor.Now i want to create one table columns with that names.For ex: If the cursor returns XYZ,ABC then want to create table  with xyz....(more online)

   About XML queries: store and encoding questions. - I wrote a query in SQL server 2000, like select *from tblTable1for xml explicitNow I got XML file, how can I stored it to .xml file.and also I need add an additional first line to the top of the xml file like And I have addit....(more online)

   Complicated view - Hi, all, am back asking questions:I have the following 8 tables:CREATE TABLE [dbo].[FOODS] ( [FOOD_ID] [numeric](10, 0) NOT NULL , [DES] [varchar] (50) [TYPE] [int] NOT NULL , [UNIT] [numeric](10, 0) NULL ,) ON [PRIMARY]GOCR....(more online)

   Database name with special character(Urgent) - My Database name is ST_Rel_4.050_TestWhen i fire query in select * from ST_Rel_4.050_Test.dbo.sa_deskIt fails in Query Analyzer also as there is dot(.) in b/w database nameWhat to do to run this queryI have problem related to....(more online)

   Being passed on after an interview - I've been in a hiring position for the last 5yrs and the #1 thing that irritates me more than anything is when a candidate sends a sarcastic or off color email after being passed on.  (ex:  explaining to me that I a....(more online)

   Weirdest interview question? - I'm sure I'm not the only one out there who's been on an interview and been asked a question that seemed really strange.  So I figured I'd put this out there to see what other odd questions have been asked at interviews.....(more online)

   SQL DBA Position in Los Angeles Area - Client company in the Los Angeles California area (Agoura Hills) needs an SQL Server DBA  to join it's staff.85-105k range ..depends on experience.NO Relocation Assistance is provided.NO Sponsorship Available.*General De....(more online)

   Opening for SQL DBA in HP [Hewlett Packard] India - Hi Folks,Currently we're looking candidates for SQL DBAs, Oracle DBA, Windows Administrators, Unix Administrators, Storage Administrators and Citrix Administrators. You can forward your resumes to jayakumar.krishnan@hp.com or....(more online)

   Recurring values - hi,I have two tables reciept and issue.Reciept have the foloowing detailspartno date rquantity rratea 10/1/2005 50 15a 15/4/2005 10 22a 11/7/2005 40 20b 10/6/2005 30 20b 25/6/2005 15 22 Issue have the foloowing detailspartno ....(more online)

   Passing a stored procedure parameter into an IN clause - Hi All I have a stored procedure which, initially, I had passed a single parameter into a WHERE clause (e.g ...WHERE CustomerCode = @CustCode). The parameter is passed using a DECommand object in VB6.I now require the sp to r....(more online)

   c# question - Why we don't instantiate the string class in c#?Any answers will be appreciated....(more online)

   data alignment - Thanks In advance.I'm writing a report using VS2005 CR and I find myself stuck.  I have data in a table that looks sort of like this:id user test grade status statisfy1 12 pretst 30 complete good2 12 posttst 50 inco....(more online)

   How to pass XML or bulk data to stored Procedure - my self avi i m developing one application in vb6 and sql server 2000 which is run on lan.i want to send bulk data [i.e. some sort of array one can say.] to stored proc. i send it by concatenating data by "," and in stored pr....(more online)

   Performance issue with XML - Big surprise right?  Well, this one is to me.I'm in the process of changing the datatype on a table from text to XML (it was done in SQL 2000 initialy).  The front end (.NET) sends in 2 BLOB's, one of which gets sto....(more online)

   Select decimal value from XML generated with XSINIL - The select of a decimal value, from an XML string, generated with XSINIL attribute, and with NULL for the decimal value, generates the error 'Error converting data type nvarchar to numeric'.Replacing 'dec' with 'int' works fi....(more online)

   DBA''s more scarce in 2007 - We've lost 2 DBA's since Jan 07' and it's been tougher and tougher to find good replacements.  Anyone else seen a shortage in good talent?....(more online)

   Mission Critical - I used this blog post a little while ago as a starter to relate a story in my career. However I didn't really address the story in the post, so I'll do that now. In the post management doesn't want to upgrade email server....(more online)

   Hard at Work - I have a great job. I tend to work a 40-45 hour week, flexible, at all hours of the day and night, and seven days a week, but it's on my schedule and I rarely have any time-sensitive work. So I can delay something for a f....(more online)

   The Problems with SSIS - I saw quite a few blogs referencing this entry, and no, the links aren't listed below. That's one of the reasons this newsletter is valuable. I spend the time going through sources and consolidating and limiting what you ....(more online)

   The July Car Update - As many of you know I like cars. In fact, driving my car around Denver to get to baseball games is almost as much fun as playing. So this month I went to the UK, really just Cambridge, to visit Red Gate and of course I pa....(more online)

   Stop the madness - It would be better for everyone to lock the Bankers Rounding thread.  It's deteriorated into a nasty flame war and has been going on way too long.Round to Even (aka Banker''''s Rounding) - The final fun...http://www.sqls....(more online)

   Reporting Services Security - We use a reporting product called Actuate.  Actuate has a feature called page-level security.  Basically, page-level security works like this:A user would login to view reports.  The user's login....(more online)

   Date time picker in RS2000 - HiDoes anyone know if there is an add-on for Reporting services 2000 that will give me date -time picker? orIs it possible to code this control?thanks....(more online)

   Login Failed to Reporting Services after server name change - Hello all, When we built our new database server, and changed the name to bring it into production, I lost the ability to connect to ReportServices.  I found a thread online, that had me modifying the rsmgrpolicy.co....(more online)

   Multiple Datasets in the same report in RS 2000 - HiI am copying a report from crystal into RS2000. The current crystal report has 20 small subreports in it. Now what I have done is create one report in RS2000 and I have used multiple datasets, each one connects to a differe....(more online)

   3-up Mailing Labels? - I'm trying to convert a Crystal report to SQL Reporting Services, but can't seem to figure out how to make it do 3-up mailing labels. Anyone have a clue?....(more online)

   Non-auto parameters in MDX Queries and SSRS2005 - I wrote some reports in SSRS 2000 against Analysis Server 2000. I've since upgraded to AS/RS 2005 and am struggling a bit with the MDX query builder.In 2000 I was able to (nay, forced to) put my parameters into strings into ....(more online)

   When drill down cube show different grand total - HelloWe are on AS2000, and I'm facing a strange problem...may be someone can help me.When we analyse the stock cube, for all products we have a value. For example it's X. But when we drill down the dimension to the last level....(more online)

   Measure Count where CustID is -1 - I have changed the underlying database so all NULLs are now -1 with a corresponding dimension of -1 as -- Not Known --But now i am having trouble doing the counts I want.How do I create a measure where I can:get a count ....(more online)

   OLAP cube output to Excel sheet template - Hi EveryoneI need your help. I have manage to create olap tubes which work just fine. Now, my problem is when you extract some data out of it the user must copy and paste in excel and try to modify the rows and columns put ti....(more online)

   ADO VBScript Active X - I use this script to load records from one store procedure, but after executing, we could only get one row ( the result must be 3 rows). I don't know what happened, please help me.Here is the script.Const adOpenStatic = 3 Con....(more online)

   DTS reading from Excel file - I have a DTS development task.I have to get data from a file into the database but here comes the catch. There are two excel files with the follwoing columns : 1. col1 , col2 , colx       &n....(more online)

   Step Error Description:Not enough storage is available to complete this operation. - I have a DTS package that runs intermitantly.  When I execute it from the local machine manually it executes successfully 9 out ot 10 time successfully.  When I execute it as a scheduled task, it never executes succ....(more online)

   Connection credentials - If i setup a connection to use SQL Authentication, where are these credentials stored in msdb? Moreover, if i save the package with a password, where would that information be stored in msdb or the file system?....(more online)

   Import multiple Excel Files into exciting table - I shall explain my situation (SQL 2000)I have a folder A, which contains excel sheets with the following name Services wXX.xls, XX stands for the number of the week.Now I want to import all these excel sheets with the differe....(more online)

   Sql Query - I have query that how can i do the Query for insert 2000 values only in single column.   i.e  Suppose, I have 1 Table ClientMaster in which 2 columns, ID and Name.   I want to insert in ClientMaster ....(more online)

   Upsizing Wizard skips table - I've been trying to Upsize an Access2003 database to SQL Server Express. It transfers the structure fine, but no data. It's a very simple database I created for testing, but the Upsizing Wizard in Access fails everytime to tr....(more online)

   Revisit What You Know - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/awarren/3119.asp....(more online)

   A Look at GUIDs - Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/alookatguids.asp....(more online)

   The OUPUT Command - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/dasanka/3041.asp....(more online)

   Tracking Database Schema Changes with DbPro - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3004.asp....(more online)

   The Joy of Numbers - Comments posted to this topic are about the content posted at temp....(more online)

   To Wrap or Not to Wrap - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/pressrelease/3124.asp....(more online)

   Reporting@Home: Delivering Dynamic Graphical Feedback to Participants - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/additional/3137.asp....(more online)

Finding other database objects referenced in an SP

By: Anonymous - Posted: 11/21/2006 8:03:52 AM (  (Stand-Alone SQL))

Script can be used to find out the objects which are available in other database and are referenced in your stored procedure. These objects will not be listed with sp_depends system stored procedure.