deAttach database

SQL Server Data Access

Index ‹ SQL Server

- Previous
  - 1
    - Subscription sends 2 emails The hourly subscription only sends 2 reports for the 1st hour of each day. Yes - I renamed the schedules in Management Studio to something recognizable. That's probably it, then...The hourly schedule was initially created as a daily schedule, then in Management Studio I renamed it and selected which hours for it to run... so the initial schedule would only be once each day, and the renamed would be once each hour. that would explain it. I will create another schedule and not rename it to test. What's the workaround when renaming a schedule Tag: deAttach database
  - 2
    - String constants must end with a double quote. ="select r.Questionid, Questiondesc, r.loannum, a.FirstName + ' '+LastName [Name], r.rating from customersurveyrating r inner join customersurveyquestion q on r.questionid = q.questionid inner join loan l on l.loannum = r.loannum inner join Borrower a on r.loannum = a.Loannum where ("+ iif(Parameters!Type.Value="LoanOfficer","LoanOfficer","Processor") + " = @Names or @Names ='-ALL-') and Len(questiondesc)>0 and a.Borrcode = 1 order by questiondesc" Tag: deAttach database
  - 3
    - Last working day from last year! Not sure what this has got to do with SSIS. Which country are you in Because different countries have different public holidays around the end of the year and this obviously makes a difference. -Jamie Tag: deAttach database
  - 4
    - PDF Rendering bug Thanks for the information. Actually we are moving a fully formatted report from an old DEC Alpha system to .pdf files. Currently this is done manually. It is a process that involves cutting and pasting hundreds of pages of the original report into output for individual departments. The SSRS report consists of a single text box to hold the lines of the source report. That is why we have leading spaces. We are able to do all the breakout of individual sections using SQL Server, but It looks like we will have to find another product to do the final conversion from text to .pdf. Actually, tiff files come out great, but they are huge and slow. Thanks again for the good information. Tag: deAttach database
  - 5
    - Relationships vs. no relationships I think that it is a mistake to assume that at all times, all airlines serving the same city pair will have the same prices and same fare dates. In my opinion, you don't need a third table at this point, add the AirlineCode to the Airfares table. Don't make it more complex than required. Tag: deAttach database
  - 6
    - Merge replication reinitialization deleted all data Yes it was from the UI and the box marked "Upload data before reinitialization" was checked. Tag: deAttach database
  - 7
    - How to create a SAPConnection in .Net Code with .NET Data Provider Correct! That really helped me out! Thanks. Tag: deAttach database
  - 8
    - What advanced features can be built with code in SQL Server 2005 Reporting Services? Hi, Andrew, Thanks a lot for your help. Very useful. Basically the functionalities I am looking for are : can we highlight any exceptions once some figures are out of normal values Can we drill down the reports to new page with different layout and columns from the page drill down happening Also, can we display series in different chart types (like I have 2 series, and I would like to display them in different chart formats within the same chart report), and also, can we have more than one scale displaying two different metrics in the same chart report (like if we display two different metrics, then they have very different value ranges, so it is better if we can have two different scales for these two metrics in the same chart report. Thank you very much. With best regards, Yours sincerely, Tag: deAttach database
  - 9
    - Accessing a real table from inside a TV UDF Data access is not allowed in this context. Either the context is a function or method not marked with DataAccessKind.Read or SystemDataAccessKind.Read, is a callback to obtain data from FillRow method of a Table Valued Function, or is a UDT validation method. Tag: deAttach database
  - 10
    - Adding a article causes ALL articles to be refreshed I have tried using sp_article. The problem is that it gives me the error: Cannot make the change because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force the change and invalidate the existing snapshot. And in order to avoid the error, if I use the Option of @force_invalidate_snapshot=1, then again I am back to where I was before and it re-initializes everything. BTW, What does IIRC mean Thanks, Amir Tag: deAttach database
  - 11
    - Making a report smaller...? You can put your table into multiple columns on the page by: From the main menu, select report|report properties select Layout tab Change the columns to 3 type 0in for spacing and .5in for the margins check it out in preview these instuctions are from the book SSRS2005 by Brian Larson, get your own copy from Amazon Tag: deAttach database
  - 12
    - Connect to SQL Server from a PDA You are mixing SQL security and integrated security - remove "Integrated Security=SSPI" from your connection string. Tag: deAttach database
  - 13
    - Installing Express toolkit Hi I am running XP Pro SP2. Tag: deAttach database
  - 14
    - SQL using 2003 AD Groups We have began to use Windows AUthentication for our SQL 2000 Server. When we llok atthe groups in AD we do not see any Domain Local groups Is there a reason for that Can I just add the group without browsing I assume DLG will work with SQL for security. Thanks Brent Tag: deAttach database
  - 15
    - How to find out PublicKeyBlob After you run the command, I think if you RightClick -> SelectAll, then hit the Enter key, it should copy the entire command prompt contents to the clipboard for pasting. Tag: deAttach database
  - 16
    - SQL Server Windows Auth for ETL called by CreateProcessAsUser Hi, I was already able to solve the double-hop issue for this. Though, I have problems. First, the ETL (or dtexec) does not run when the impersonated user is not part of the locla Administrators group and having the local privilege "Replace a Process Level Token". Having those rights assigned, the ETL runs but again fails because it can not connect properly. Based on my logs, the impersonated user is the "operator" or caller of the dtexec but when it tries to connect to SQL server, it does not use the impersonated identity but it uses "NT AUTHORITY/Anonymous Logon". Because of this the ETL call fails. I've researched some, can "cloaking" (COM) help here Thanks! Any help is appreciated! Tag: deAttach database
- Next
  - 1
    - Cannot add a new folder under a Reporting Server Project Hello, I was just wondering why is there no option to add a new folder under a reporting server project. I have a reports project and under it i would like to add subfolders like Daily and Weekly just to make it more organized. I understand that during deployment, we can specify to which folder we want the report(s) to be deployed, but what is the reason behind not having an option to add a new folder Thanks, maui Tag: deAttach database
  - 2
    - Generic calculated measure You can also create is as a calculated member in a seperate dimension called ValueType or something. I can't give you tested precise answer because i'm installing SP2 at hte moment, but for your example it would look something like create calculated member CurrentCube.ValueType.Ytd as sum(ytd(); It will display the Ytd of whatever measure is in context. If it should only apply to certain measures you could scope on those. Regards GJ Tag: deAttach database
  - 3
    - SSIS Randomly Empties Out Column Data While Using Flat File Source Seemingly it is the Object Model. I load the package using Apartment Threaded. LoadPackage([FilePath], null). The null sets it to using Apartment Threaded where as the other method uses Neutral Threaded. I am calling it through a webservice which shouldnt cause a problem, which means that all the code used to provide properties and set various variables inside the package is on the server. I want to see if I get any responses here on this issue. Opening a ticket with Microsoft is definitely my next bet. Tag: deAttach database
  - 4
    - Validating the parameter text box Hi, I have one date parameter in my report. The user will be able to manually enter or use the calendar control. In the case of entering manually, is there any way to validate the input string How can we prevent users from entering alphabets Also, is there any way to reduce the length of the parameter textbox. Can you please help Thanks, Sonu. Tag: deAttach database
  - 5
    - aggregation question Do you mean 'product' as in factorial Tag: deAttach database
  - 6
    - date output format Hi, Thanks for the quick response. This works great. Greetings Vincent Tag: deAttach database
  - 7
    - how to change the actual data filename i'm hoping someone can help me out with this problem. i have a database called Tracking.mdf and its associated logfile Tracking_log.ldf i need to build another database based on the above with more tables and keep the data separate hence the requirement to make a copy of the tracking data file i've tried changing its name but it will not attach. i can change its database name to whatever i want but somehow can't find out how i can say change its actual filename to Tracker.mdf and Tracker_log.ldf would someone be able to help me out. thanks. Tag: deAttach database
  - 8
    - MSResultSetGenerator does not work any more Just as a thought - have you tried running VS2005 as administrator and see if you have the same issue. Be warned VS2005 under Vista is still not officially supported as they haven't released the update yet - the beta fixes some, but definitely not all the Vista related issues. Tag: deAttach database
  - 9
    - Best Practice for Counts/Distinct Count Measures for Filtered Data Darren, I had a feeling that these 2 alternatives would not produce the same results when I was typing up the question. Perhaps my example scenario wasn't a good one, because the limited testing with my applicable situation yielded the same results. In any event, I will just go ahead and go forward with the separate measure group with the new Named Query approach. Thanks! Tag: deAttach database
  - 10
    - another dynamic assembly loading problem (XmlSerializer) In order to get Visual Studio to actually build a serialization assembly, you have to both 1. Set the "Generate Serialization Assembly" to ON, and 2. Add, by hand, the following SGEN task to your project file: < Target Name = " GenerateSerializationAssembliesForAllTypes " DependsOnTargets = " AssignTargetPaths;Compile;ResolveKeySource " Inputs = " $(MSBuildAllProjects);@(IntermediateAssembly) " Outputs = " $(OutputPath)$(_SGenDllName) " > < SGen BuildAssemblyName = " $(TargetFileName) " BuildAssemblyPath = " $(OutputPath) " References = " @(ReferencePath) " ShouldGenerateSerializer = " true " UseProxyTypes = " false " KeyContainer = " $(KeyContainerName) " KeyFile = " My_Key_File.snk " DelaySign = " $(DelaySign) " ToolPath = " $(SGenToolPath) " > < Output TaskParameter = " SerializationAssembly " ItemName = " SerializationAssembly " /> </ SGen > </ Target > There is, however, a major problem with this approach: The SGEN task will only execute AFTER all post-build events have fired. Thus, if you have a post-build event that copies the serialization assembly to, say, a deployment folder, it will copy the old one because the copy occurs before the SGEN task is executed. This problem is best resolved by running SGEN from a post-build event like so: sgen /a (ProjectDir)$(OutDir)$(ProjectName).dll /compiler:/keyfile (ProjectDir)My_Key_File.snk /f But this is where your problems really begin. The only way I have been able to get SQL CLR to actually load the serialization assembly is to apply the XmlSerializationAssembly attributes to my serializable classes AND load the serialization assemblies into the GAC and SQL CLR. I have described this in detail in a previous post and it is the ONLY way I am able to invoke XML serialization from within a SQL CLR procedure. Developing SQL CLR components is substantially more difficult than it needs to be due to issues just like this - and documentation is almost impossible to find for all but the most trivial use cases. I was very excited about the integration of SQL Server and .Net. After having worked a bit with this technology though, I am much less enthusiastic.... Tag: deAttach database
  - 11
    - How do you add multiple data sources to a report? The only way I've found to combine data from different data sources into a single dataset is to use techniques like OPENROWSET or use linked servers at the SQL Server level. RS cannot combine data from 2 data sources into one dataset and cannot internally join 2 separately retrieved datasets. Tag: deAttach database
  - 12
    - How to capture error upon connect error? I would like to continue processing when a connect error occurs. Set oServer = CreateObject("SQLDmo.SqlServer") oServer.LoginSecure = True oServer.Connect oName Would like to continue if the connect fails rather than have the script fail. How do I do that Thanks! Tag: deAttach database
  - 13
    - Server Upgrade We currently have a stand alone production server SQL 2005 STD + SP2 and plan to upgrade to clustered SQL 2005 Ent + SP2. What's the proper way to upgrade I want the existing server instance use Ent engine. Tag: deAttach database
  - 14
    - How to reflect base table changes in cursor Below is my complete code. It select the range of records from the base table and insert into a different table and then deletes those records from the base table but when i debuged the cursor i am still getting the value of time_encoede which should be deleted. declare @pgname nvarchar(20) declare @videorelease nvarchar(40) declare @dateaired nvarchar(15) declare @dateencoded nvarchar(15) declare @timeencoded nvarchar(15) declare @network nvarchar(12) declare @count int declare localshowcursor cursor for SELECT video_release, programname, network, date_encoded, time_encoded, COUNT(*) AS Number FROM SigmaStageTemp s Where program_type = ��1�� Group by video_release, programname, network, date_encoded, time_encoded Having count(*) >= 10 Order by video_release, programname, network, date_encoded, time_encoded OPEN localshowcursor FETCH NEXT FROM localshowcursor INTO @videorelease, @pgname, @network, @dateencoded, @timeencoded, @count WHILE @@FETCH_STATUS = 0 BEGIN Insert into sigmtemp(Video_release, country, market_rank, Designated_mrkt_area, station, network, date_aired, day_of_week, day_part, half_hour_aired, programname, program_type, start_time, end_time, length_aired, date_encoded, time_encoded, rel_type, VR_CODE1, VR_CODE2, VR_CODE3, VR_CODE4, DMA_CODE, sid_code, station_code) (Select top(1) Video_release, country, market_rank, Designated_mrkt_area, station, network, date_aired, day_of_week, day_part, half_hour_aired, programname, program_type, start_time, end_time, length_aired, date_encoded, time_encoded, rel_type, VR_CODE1, VR_CODE2, VR_CODE3, VR_CODE4, DMA_CODE, sid_code, station_code from sigmastagetemp s1 where s1.video_release = @videorelease and s1.programname = @pgname and s1.network = @network and s1.date_encoded = @dateencoded and convert(int,s1.time_encoded) between convert(int,@timeencoded) -2 and convert(int,@timeencoded) +2 Order by video_release, programname, network, date_encoded, time_encoded ) Delete from sigmastagetemp where video_release = @videorelease and programname = @pgname and network = @network and date_encoded = @dateencoded and convert(int,time_encoded) between convert(int,@timeencoded) -2 and convert(int,@timeencoded) +2 FETCH NEXT FROM localshowcursor INTO @videorelease, @pgname, @network, @dateencoded, @timeencoded, @count END CLOSE localshowcursor DEALLOCATE localshowcursor Tag: deAttach database
  - 15
    - Memory allocation error while processing cubes I am using Analysis Services 2005 Enterprise Edition with (to my knowledge) the latest service pack, version 9.00.2047.00. Tag: deAttach database
  - 16
    - Performing insert / update queries using Pocket PC / SQL CE The SDF file's held on the storage card as opposed to the program files with the rest of the application. The same happens for any update/insert queries I apply to the database using Query Analyser, they're simply not there when I restart the program... Tag: deAttach database

Sami Karaeen

is there way by code to stop the sql server service and deattach a database and then restard the service

thanks

Top

Re: deAttach database

Caddre

You can detach a database with code but SQL Server service must be running because if it is not running, you cannot access anything in SQL Server. Try the link below for details about attach and detach database in SQL Server. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms187858.aspx

Top

Re: deAttach database

Sami Karaeen

thanks , but do u know how can i stop the sql server service

Top

Re: deAttach database

Caddre

Yep here is some sample code from Microsoft to get you started. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms162139.aspx

Top

Re: deAttach database

Sami Karaeen

thanx a lot

Top