Answer Questions

• Mark Hollman SQL 2005, Limit to the number of variables

  Hi all Is there a limit to the number of variables that a stored proc can use in sql 2005 (June CTP)   A proc I use under sql 2k has 975 variables, it runs fine there but in sql 2005 half of them return 0 or Null.  All should have values. thanks There is no limit and it hasn't changed from SQL Server 2000. Are you sure that this is not a data related problem or logic issue If you can post a simple rep ...Show All

• Maojiu Move data from backroom to frontroom

  I need to know the quickest way of moving/copying data from a backroom/import/qualitycheck database to the production environment. The databases reside on the same server instance, the tablestructure is identical and I'd preferably like to use T-SQL procedures, rather than DTS/ETL. Can I make use of bulk loading, openrowset or ... from one table to another Hi Erik, There's certainly nothing stopping you fro ...Show All

• Vikas Pradhan Watermark Generation is Invalid Error

  We are currently doing a proof of concept using SQL 2005 merge replication.  However we are currently encountering the following errors: "The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up." " The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be los ...Show All

• Bob1945 SQL ALTER COLUMN causes a Possible schema corruption.

  Hi all, I’m trying to run this SQL statement in 2005 express; ‘ALTER TABLE test ALTER COLUMN testfield varchar ( 5600 ) NULL’ Testfield exists in database as a varchar(8000). Express bombs with; Msg 211, Level 23, State 7, Line 1 Possible schema corruption. Run DBCC CHECKCATALOG. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be ...Show All

• notoryus SSMS-EE: Creating and Using Stored Procedures - Error Messages 111, 156, & 102

  Hi all, I tried to use the SQL Server Managemet Studio-Express Edition to execute the following code statements: --- SQLQuery.sql--- USE testDB DECLARE @procID int DECLARE @procName varchar ( 20 ) DECLARE @procType varchar ( 20 ) CREATE PROC sp_getRecords AS SELECT * FROM Inventory CREATE PROC sp_insertRecord @procID int , @procName varchar ( 20 ), @procType varchar ( 20 ) AS INS ...Show All

• TOM A. synchronization for PPC w/o internet

  Hi.. need some help!      My problem is thus - I am looking for a synchronization technique (between SQLCE and SQL Server 2000) for a PPC which can not connect to the internet. I am not sure at this stage if the device would even be equipped with a network adapter.I would be using RDA to sync with the database. The only problem is that I am unable to access IIS directly from the PDA.     I did some res ...Show All

• Carol Beth Execution not found when using Dynamic Windows Impersonation

  Hello, We're trying to use dynamic windows impersonation and URL access to display our reports in the HTML viewer using ASP.NET. Before switching to dynamic windows impersonation we were using static windows impersonation in our web application's web.config file.  For example: <system.web> <identity impersonate ="true" userName="ourUsername" password="ourPassword" /> </system.web> The static windows impersonation worked ...Show All

• Rebecca Karma Can replication be ran on a MS sharepoint database?

  Hello, I was curious if you can have merge and/or snapshot replication setup on a MS sharepoint database Thanks. John Jaydog, Thanks for your reply. John Jaydog, I was curious if you had an update on this John Jaydog, I look forward to what you find out. John I don't thin ...Show All

• Nahum MySQL OLEDB Driver

  Hi! I have a small question, there are OLEDB drivers availible for .NET on the MYSQL download site. But when I install them I'm not able to see them inside SQLIS, I've tried them inside Visual Studio and they work fine. Is there a way to get them "registred" or add them as a reference inside SQLIS so that I may choose them when setting up an OLEDB Source / Destination Don't think that's the problem, I think the problem is that the driver ...Show All

• Ricky Wen - Microsoft Freeze Panes

  I have created some reports in RS that contain alot of information. The problem I have is that at the top of the list it is fine, but when you start to Drill Down and then scroll down the list, the column titles disappear. So the question is, how can I freeze the horizontal and vertical panes, or should I say, can I freeze those panes Regards Note: the FixedHeader feature is only available in RS 2005. You can use it in tables and i ...Show All

• dreamworks Object Explorer/Server Explorer Error

  I have just installed the released VS2005 as well as the released SQL2005.  When ever I try to browse my SQL Server with either the Object Explorer in MS SQL Server Management Studio or the Server Explorer in VS2005 I get the following error: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM componen ...Show All

• Larantz Grouping question

  Hi guys, on my report i have 3 separate matrices with monthly sales results, each gives a different view on the same data. This all works nicely, but the customer wants these matrices grouped by product (the product is a parameter of the report, they can choose several or all products to report on).   Exactly what would be the best way to achieve this grouping It seems i can't house them within a table, and i can't put them in anot ...Show All

• Charles Berry I have an error while connecting to sql server 2005

  When I try to connect to server in SQL Server Management Studio TITLE: Connect to Server ------------------------------ Cannot connect to OMER. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provi ...Show All

• SREI Help getting mirroring working

  Hello guys and gals, I've having some trouble getting DB mirroring set up in Sql Server 2005. Perhaps someone can help, as I've read everything I can find on the web and Google groups about this but still can't solve it. Here are the steps I have taken: 1. Installed a fresh Windows 2003 on box A (the primary) and a fresh Windows XP on box B (the mirror). 2. Run Windows update on both. 3. Installed Sql Server Enterprise on box A and box B, ...Show All

• l.walt Retreiving TableAdapter data into variables

  SQL database    ID   FName    LName    SSN    Dept   Photo   JobReview   PayGrade me.TableAdapter.GetDataBy(LName) I would like to access the TableAdapter records and read a row into variable to be displayed such as textboxes and picturebox How do I access a row How do I specify each column to read Do I need to convert Photo into grap ...Show All