Answer Questions

• yassir Adding logins and permissions

  Hi, I am at a company with 18 employees and I have 11-12 databases in SQL server. I can't seem to give logins and permissions to groups. Is there a simpler way, or do I have to add every single employee to each database and give permissions You may create roles (it's a group analogue) within databases and then assign your employees to these groups. There are no serverwide groups except of builtin server r ...Show All

• Didier Levesque Broker:Corrupted message

  Hello, Has anyone seen this in profiler I have two brokers on different servers with one of them being the initiator. All messages end up sitting in the initiator's transmission queue. Profiler on the target broker's machine displays this for every attempt to send by the initiator: A corrupt message has been received. The End of Conversation and Error flags may not be set in the first sequenced message. This occorred in the message with Co ...Show All

• Gary Wang Concatenating Numeric Fields

  Friends, I am attempting to concatenate two numeric type fields together with character data and the query is adding them together. I am assuming I need to convert the ints to a string type but would appreciate some info on the best way to do this...I am sure it's something simple but am not finding much on the web about it. SELECT vehFacID + '-' + vehID AS vehNew FROM Vehicles Returns the sum of vehFacID & vehID. Doh! ...Show All

• smtraber database restored, publications gone

  hi all, our datbase was restore but the publications were all gone. however replication monitor shows publication and subscription. worst. can create the publication with the same name because it raises an error saying that it can't drop publication becuase there is a subscription in it. how can i remove the publication when the are already gone in the publication folder but exist in the replication monitor thanks ...Show All

• Moshazu Combining text data rows

  I am working with a database derived from text documents. One of the tables (TEXT001) contains the text of the documents with each paragraph of each document assigned to its own row with a paragraph number in a SectionNo column. I want the entire text of each document in a single row with its own unique number (so that I can do a full text search with SQL Server 2005 that will search and return the entire document as a result). How do I comb ...Show All

• vB d0t NeT SqlServer2005 can support merge replication with SqlCe2.0??

  Hi guys, Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2. But the following errors are wat I've got during the syncronization: Error Code: 80004005 Message : Run Minor Err.: 28557 Source : Microsoft SQL Server 2000 Windows CE Edition Err. Par. : ssce:database;password=mypassword;data source=Program Files\helloWorld\database.sdf; Error Code: 80040E14 Message : The OLE DB Execute method failed. ...Show All

• Mark Blackburn SQL Server 2005 Express Detach from a database at runtime

  Hello all! I need to detach from a databse on a SQL Server 2005 Express at runtime, in order to restore a backup (just copying the files). Actually I have no idea how. I found something about a stored procedure called sp_detach_db and built the following code sample. private void detach_db() { this .sql_connection.Open(); SqlCommand _cmd = new SqlCommand ( "EXEC sp_detach_db @DB" , this .sql_connection); _cmd.Param ...Show All

• Dataman911 Can't Debug a script task

  After upgrading to CTP16 (Sept.), I can't seem to debug my script task. Everytime I run the package with a breakpoint in script task I get following error: "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for the inconvenience. " If I remove the breakpoint the scrip task runs successfully. So my question is how do I debug a script task with CTP 16 Th ...Show All

• Keith Newman script in removing primary key..

  help, I need it now, I need a script for removing a primary key constraint. thanks ALTER TABLE Tbl DROP Constraint_Name -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < yngielkoh@discussions..microsoft.com > wrote in message news:a9440570-7c86-4f01-a3b8-6e5926206112@discussions.microsoft. ...Show All

• Sajid Saeed Upgrade from June CTP to Sept CTP - BKM

  I am upgrading to Sept CTP from June CTO. Should I completely uninstall the June version before proceeding towards the new version Any experiences Pls share. I've had hassles on a 64-bit platform that also has SQL 2000 installed. The Sept CTP install errors due to a DLL already registered as a 32-bit proc (MSMQTask). This CTP doesn't seem to work well with the June CTP either, I get errors when trying to object ...Show All

• theumpteenthbrian Tell Us Your Express Story and Win $100!

  Want a chance to show off a cool way you’re using Visual Studio Express or SQL Server Express We’re looking for your stories! Tell us about something that makes your life easier or is just plain fun and if we like it enough to include in a feature article, we’ll give you a $100 gift certificate to Amazon.com! http://msdn.microsoft.com/vstudio/express/support/hero_promotion/default.aspx Son of b**&*#! I instal ...Show All

• Joseph Lee Disregard: SSIS as data source for reporting?

  I'm trying to develop a report using an SSIS DataReaderDestination as the reports data souce.  When I attempt to create the report DataSet, SSIS is not an option for the Data Source parameter.... Is there an OLE DB or .NET provider for SSIS that I need to install apart from installing reporting services Hello, I am experiencing the same problem you described. I have Visual Studio Team Suite installed with ...Show All

• The Goblin Resources about Load/Run SSIS packages using .NET Remoting.

  Hello, I don't have a specific problem, I'm looking about resources because this is the tipical case when something is working but I don't know why .. On particularly I have to load and run a dtsx package from a window application and the package is located on the server. I decided to use .NET Remoting. I developed my "Remotable Object" which contains: package = Microsoft.SqlServer.Dts.Runtime.Application. LoadFromDtsServer() packag ...Show All

• BungleDave import/export tools

  I install sql2005 final and the SQLServer2005_SSMSEE.msi ... but i don’t find de import/export tools. I need import a DB from MDB to SQL 2005. Thanks The import/export wizard in SQL Server 2005 Management Studio relies on SQL Server Integration Services to do its work.  SSIS is not included with SQL Server Express, so we removed the import/export wizard in Management Studio Express. You can use the Access Upsizing Wizard th ...Show All

• Epsilone3 Updating a record from table with data from a column of another record from the same table

  Hey guys, I have a table say as follows id, id2, field1, field2, date1, date2 I want to update the date1 field to the date2 field of the very next record with the same id2. In short I want to update a record id(x) by putting in the date2 field if id(y) in the date1 of id(x) where id2(x) = id2(y) and id(y) > id(x) (as id is a sequence). I have written a query as below: update t_remarks te set out_date = (select TOP 1 date_remark_entered fro ...Show All