Answer Questions

• Tom Lake - MSFT New Query Connect Dialog

  The "Microsoft SQL Server Management Studio" opens a connection dialog with every new query. Please tell me there is setting to prevent this. Thanx, Greg Thank you for your reply, your answer does work nicely. It would seem this would be something you could define a default for. It is taking a little time to get used to the SQL 2005 tools after using SQL 2000 for so long.   If you are a member of Expert ...Show All

• Rui Moraes Converting identity column to "not for replication"

  Is there a good way in sql2k to change an identity column to "not for replication" without recreating the table and moving the data I'm thinking of setting syscolumns.colstat to (value) | 8, since that bit appears to be control "not for replication". But I've been a sql dba for 8 years and I can't remember when I've ever had to update a system table -- I'd rather not start now. Thanks, Mike ...Show All

• bulklodd How do I find IDENTITY columns on Table using T-SQL

  Is there a query I can write against an INFORMATION_SCHEMA or against the system tables to determine if a column is an identity column Here is some more ( in technicolor ;-) ) USE northwind GO DECLARE @tableName VARCHAR (50) SELECT @tableName = 'orders' --Use COLUMNPROPERTY and the syscolumns system table SELECT COUNT (name) AS HasIdentity FROM syscolumns WHERE OBJECT_NAME (id) = @tableName AND COLUM ...Show All

• NeilG is it a bug ? (relationships in report builder)

  Hi friends am having some weird problem.am using sql server 2005 standard edition. i've a report model with tables (tab1,tab2,tab3). tab1 and tab2 (actually these are views) relate to same table but each has different columns from same table. the third table i.e. tab3 is child of tab1. in my report model project,i set cardinality of this role in tab3 as "one" and in tab1 as "Optionalmany". when creating a report in reportbuilder.if select colum ...Show All

• MoFe My Mobile DB.

  Dear MSDN Support, It is pleasurable being in contact with you and getting the desired support, for that i am feeling free inquiring about some aspects related to my graduation project. Well here i am facing a problem with my database. I had created a full Pocket Pc project i added references, datasources and data connection for the SQL Mobile Database i am using. While i do an query like insert,update, delete, select it works on the pocke ...Show All

• mahes SSIS Connection Object and Expressions

  I have been writing a custom source adapter that uses a file connection within the connection manager. If I hard-code a specific file then the component works. However if I use a file connection that has an expression defined which updates the connection, for example when you have a for-each loop looping over a set files. The file connection doesn’t seem to re-evaluate expression each time you access the file connection via the code. Is there s ...Show All

• Paulg742 SQL Express & Reporting Services

  Hi, I believe SQL Express is going to get Reporting Services in a point release. Anyone know when that might be I urgently need the functionality and the db is currently not big enough to warrent shelling out for the full SQL server package. Thanks Sorry. Should have mentioned the Service Pack is not due out for another couple months. I do not know the exact time. Look Reporting Ser ...Show All

• gmcbay How to browse cube in Excel?

  Hi, all here, Could anyone tell me how can I browse cube data in Excel Thanks a lot in advance for any guidance and help. Hi, I have downloaded and installed the add-in. When I try to connect to the database I get an error with Initialization of the data source failed. Can one one help me on this cheers Josh Hi, Steve, thanks a lot. There are two options I know of. ...Show All

• Anonymous Hacker Selecting ProfileName to use by the SQLMERGXLib.SQLMerge

  Hi I am trying to set the profile name for the merge agent to use during replication. currently I am setting .ProfileName = "High Volume Server-to-Server Profile" But it still defualts to the defualt profile during merge. Has anyone had any luck in setting the profile I know I can do it opn the server but we are imaging the computers on the lan first and then rolling them out to the client sites.  Some will be only using dial up to merge c ...Show All

• Wayne Gibson Can't Connect to SQL 2005 Express Edition via Server Manangment Studio

  I have installed SQL 2005 Express Edition on a Windows 2003 Web Edition server. Everything installed correctly, no errors to be found. I also have: Local & Remote Connections using TCP/IP only turne don SQL Browser is running as well. I have tried connecting with the most recent CTP of Microsoft SQL Server Management Studio Express 9.00.1399.00 When trying to connect using the SA account I recieve: 'An error has occured w ...Show All

• Giedrius Banaitis How do you use the upgrade.exe for sqlce 2.0 to sqlce 3.0?

  Does anyone have any instructions on how to go about uprading a .sdf file from sqlce 2.0 to sqlce 3.0 I found this on an msdn website (link: http://www.microsoft.com/sql/editions/sqlmobile/upgrading.mspx ) but as you can see its very lacking on detail. (I included the link and content referring to upgrading the database files so you won't have to go to the link to see the part referring to upgrading the database.) I tried to run the upgrade.e ...Show All

• MelGrubb Books on SSIS programming

  Hi, Can you please suggest the books which cover SSIS programming in C# Regards, Gopi http://www.amazon.com/gp/search/ref=br_ss_hs/102-1412231-0916156 platform=gurupa&url=index%3Dblended&keywords=ssis -Jamie ...Show All

• MichaelChesapeake Where are the SQL Management tools???

  I just finished installing SQL Server 2005 Developer Beta 2. There are no menu items for the manager or any thing else. Where are these things installed.  How do I access them Hello, I am having the exact same problem with SQL Management Studio not showing up. I am installing the Developer Edition. I first began by doing a normal install, but then I decided to individually select the components. Now, I'm receiving the following err ...Show All

• Nate of T Incorrect results from FTS on multiple columns

  I'm writing a FTS query which needs to search on two different columns. E.g. Table contains "Location" and "LocationDescription" columns. Both columns are FT indexed. The query also uses AND/OR operators to filter out the results. I found the following article which gives the solution to the same problem. Link: http://support.microsoft.com/default.aspx scid=kb;en-us;286787 Is this problem associated with SQL Server 2005 also ...Show All

• Christopher Ambler Sql server Express edition installation (OS Windows Home XP)

  Hi, I am trying to install SQL Express on Window Home XP and SCC is returning the following error: The SQL Server Configuration Checker cannot b execute due to WMI configuration on the machine ..... Error 2147942405 (0X80070005). I tried running the following batch file which I believe resolved the same issue that someone else raised earlier (though I am not sure whether the OS was Home XP) Will upgrading from XP Home to XP Professio ...Show All