Answer Questions

• Mike Hollibuagh Importing XML into SQL using a Timespan datatype

    I'm working on a .Net app that generates the following XML directly from the datagrid object I'm using(via writeXML).  It is a log of sorts.  Within the datagrid the ExecTime element is a Timespan datatype, it holds a duration of time.  As you can tell when dumped to XML it appears unreadable, however I'm assuming that once imported into SQL it will mean something again.    <Packages>   ...Show All

• Drew P Custom aggregate function

  hi how do i write a custom aggregate function or select query.I have Table name MemberDetail where which has two column Memberid and WokingDay.In this table same member could have multiple working days. i want select query that will return single row for each member and his/her quama separated working days. without using cursor. how do i do that. eg Table MemberDetail MemberID WorkingDay M1234 12 M1234 10 M1555 ...Show All

• wistful_donkey Variables Window is missing (hidden?)

  Hi, I wonder if anyone ran into this issue. When designing SSIS package I can't seem to display "Variables" window. Right clicking on the design surface and choosing "Variables" has no effect. Also when I go to View -> Other Windows, there is no choice "Variables". It must be some envinronmental settings, I guess. Any help is appreciated! - Michael ...Show All

• prathima.k Using result sets from a stored procedure

  Is it possible to access the result set returned from a stored procedure For example, begin    set @cursor_list = sp_spaceused 'a_table'    ...loop through here... end I can't seem to find any information on accessing the "default result set(s)". Returned from a stored procedure. What I really want is the output of sp_spaceused for all tables for a particular user. Thanks Tory http:/ ...Show All

• tk18 Problem in bulk insert

  Hi All, I am trying to perform Bulk Insert for an existing folder containing the data files into an existing destination table . I get the following error : [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\PD Data\PDDW_md_costs\Files_to_load" could not be opened. Operating system error code 5(Access is denied.).". Here Files_to_load ...Show All

• Jon_DEV how to enable Model item security ?

  Hi friends how to enable Model item security i found followin link that talks abt this http://msdn2.microsoft.com/en-us/library/ms156505.aspx extract from abv link Securing items in a model requires a report server connection in Management Studio. To secure model items, the report model must be deployed on the report server. In Management Studio, connect to the report server that stores the model. In Object Explorer, navigate to t ...Show All

• jjparker SQL Login failed

  hideho mates, well could it be.... all SQL services r runnin, i created 2 sql logins with ALL rights!!!!! well now i want to use one of this accounts (which r domain admins too) too install VSTFS 2005 Beta 2...so far so good...but the first evetnlog entry after the begin of the install is always "sql server login failed - cannoct connect to the database"... the funny thing is > AFTER is event log entry ALL VSFTFS and ADAM Databases gonna  ...Show All

• CFMtch Bulk Insert -- Access denied issues - 2

  Hi All Same situation as described here , same issue. SQL Server(SQL2005 on Windows2003) uses domain account. This domain account enabled to be trusted for delegation. Client connects to server using Windows auth. Client issues BULK INSERT with UNC path. Statement returns error: Cannot bulk load because the file "\\Server\pub\file.txt" could not be opened. Operating system error code 5(Access is denied.) SQL 2000 runs this s ...Show All

• Thaedrys SQL Server Mobile tutorial and getting proper mobile DB installation

  Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem. I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information. I've gotten almost all the way through... successful ...Show All

• Stefanie cant start the sql server services

  Hi all After i configure the Merge Replication, my sql server services wont start again. The error show that "The request failed for the service did not respone in time fashion. Consult the event log or other application error logs for detail" >>The error show that "The request failed for the service did not respone in time fashion. Consult the event log or other application erro ...Show All

• RistoM Server Availability

  I am in the process of setting up server replication using the Central Publisher Model. We are doing this for application availability. The application is a .NET app and this application uses the SQL Server name in the connection string. As far as I know we can’t have two severs on the same domain with the same name. So if our primary server (server A) goes down and that server name is in the connection string how does the application get r ...Show All

• matteo raumer GUID

  Hello, I'm working on a smart client app that has an offline sql express store and needs to work with several types of central databases (support for multiple products - ms sql, DB2 etc) While trying to put together some offline functionality that needs the user to create records on the offline sql express data store, we've run into the need of being able to uniquely identify records so replicating the data in the offline store back into t ...Show All

• anand singh Where can I find SQLCMD?

  Hi, all here, where is the SQLCMD (to run sql scripts). I mean I did not find SQLCMD on the SQL Server tho. Thanks a lot in advance for any help. Hi, Jens, thanks a lot. Found it in the folder. But I cant run sql scrit in it tho. Could you please tell me how can I run any sql script in it (I have my database .mdf and .ldf files available, I wanna attach the database to the SQL Server instance through this command window) Thanks a ...Show All

• Fahd Select Top @variable

  I want to do something like this: SELECT TOP @variable. I cannot use stored procedure for this report, 'cause I do not have access to prod db, I'm just sending rdl for upload. How to make it work on dataset level or through the report layout I know SQLServer doesn't recognize "Select Top @variable" statement.  SELECT    top &variable, Ticket.problem AS Issue, COUNT(Solutions.solution_date) AS [Tickets Touched ...Show All

• Dati.MCAD Null values

  Hi, How can I use "Derived Column" to check if a Datetime value is null or not and if null to insert  00/00/00 instead. The background being that while using a "Derived Column" to change a Column from a (DT_DATE) to a (DT_DBTIMESTAMP) everytime I get a null value it see's it as a error. And the column in particular has ~ 37 K blank / null fields so Im getting a lot of errors So far I have tried to use something like ISN ...Show All