Answer Questions

• Ed Abshire what directory are my nightly backups (.bak) files written to?

  where in sql server 2005 ( and 2000 for that matter) do i find the path to the location where backups are placed (.bak files) is there sql i can use to find this out No disagreement here. It was just another tidbit of info that might be useful :) Another place to check for the default path is the registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer There is a key called BackupDirectory that houses the defaults, though this is no guarantee, it is the default I also thought about the default setting first, but then it struck me that there's no guarantee that any given backup actually used the default path, so I thought it'd better to look at the backups taken just to b ...Show All

• Thomas Olsson How to recover from dropped tempdb?

  I am testing sql server 2005 in different disaster situations happened under 2000. I was reading a lot about no update on system tables, so: sp_detach_db 'tempdb' In sql 2000 i could issue something like the following command to recover: use master sp_configure 'allow updates' , 1 reconfigure with override go insert sys.sysdatabases ( name , dbid , sid , mode , status , status2 , crdate , reserved , category , cmptlevel , filename , version ) values ( 'tempdb' , 2 , 0x01 , 0 , 8 , 1090520064 , '2007-01-27 13:03:10.873' , '1900-01-01 00:00:00.000' , 0 , '90' , 'D:\beep\mssql\temp\tempdb.mdf' , 611 ) go sp_configure 'allow updates' , 0 rec ...Show All

• Matt Garnham Executing a whole container in one transaction

  Hello all, I am trying to build a package running a container that includes several tasks: 2 Execute SQL tasks and a data flow task. I would like to execute this container in a single transaction, which means that if any of the tasks fail, no changes are been made by the container execution. To achieve this, I have followed the instructions of how to configure the DTC on the server and locally, and set the container's TransactionOption Property to "Required". The problem I encounters is that when using a dataflow task in the container, the running process runs OK until it reaches the dataflow task, then it just gets stuck (marking the task in yellow). When removing the dataflow task, left with only Execute SQL ...Show All

• R Suresh Search and Replace only replaces one Char per field

  I am attempting to find quotes (") in a column and replace with the string '--THIS-WAS-QUOTES--'. Right now my script only converts the first quote it finds in the description column, converts to the string and moves to the next row leaving the other quotes as they were. Below is my query script DECLARE @find varchar(8000), @replace varchar(8000), @patfind varchar(8000) SELECT @find = '"', @replace = '--THIS-WAS-QUOTES--' SELECT @patfind = '%' + @find + '%' UPDATE Incident SET description = STUFF(convert( varchar(8000), description ), PATINDEX( @patfind, description ), DATALENGTH( @find ), @replace ) WHERE description LIKE @patfind ...Show All

• niallhannon ADS "System timed out waiting for lock" error

  I am attempting to modify the ADS sample to work with my own application and am running into a snag. I have a simple sqlce database that has two tables in it. I have everything working up until the point where I try to "Pull" the data. At this point in time this is what happens. 1.) I successfully Drop Table1 from the SQLCE database and then Pull " Table1 " from the desktop database 2.) When attempting to Pull Table2 . It runs the DoesTableExist Function, identifies that the table does exist and therefore tries to run the "DropTable" routine before Pulling the desktop Table2 data. As soon as the sqlCmd.ExecuteNonQuery of the DropTable routine runs I get the following error.... "The system timed out waiti ...Show All

• Mykhaylo Blishch ANSWER: SQLEXPRESS Database Issue - Cannot open database ASPNETDB.MDF requested by the login, login failed

  Hello Guys This is my connection string <add name ="ASPNETDBConnectionString1" connectionString ="Data Source= .\SQLEXPRESS; Integrated Security = True; DataBase = ASPNETDB.MDF; User ID = MyWindowsUserName; Password = MyWindowsPassword; User Instance = False; Connect Timeout = 30" providerName ="System.Data.SqlClient"/> I tried to research on the internet and i got a solution on changing the permissions for this database to enable user SystemName/ASPNET, but iam not able to access this ASPNETDB.MDF from SqlServer and if i go to server explorer in vs2005, i dint know where to chage the permissions. Can anyone help me on this. Thanks a lot Hello Ranga, Thanks a lot yar ...Show All

• needforhint Fastest way to add new instances to SQL 2005?

  Hi, I'd like to know the fastest way to add named instances to SQL server 2005 (I need to add 5 named instances) Thank you! John You will need to run setup for each instance. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog hi, Is it not possible do it by means automated files Any XML or .bat file thanks Thought so... Thanks for your answer! ...Show All

• Kyle_W remote server connection problems

  Having all kinds of problems trying to establish a connection between a VB5 application and a remote server Sql Express database. The connection works fine with a user instance on my local machine. At one time I did have the remote connection working successfully using Sql Server authentication , whereby the application was passing the login and password through the connection string as so: Provider=SQLNCLI.1;Persist Security Info=False;Data Source=<server name>\sqlexpress;Database=<database name>;Uid=<userid>;Pwd=<password>; I've been away from using this development database for several weeks. Things are little foggy from that initial effort, and I recently tried putting up a newer copy of the development databa ...Show All

• TMB NULLS --> blanks ?

  I wrote a simple data flow with an OLE DB source and destination. I do a direct mapping of the columns ( colA - > colA) with no transformations needed. I found that colA on the destinatin does not allow NULLS (required by the program that accesses that database) while colA on the source supports and has NULLs, Is there any accomodaiton for handling NULLS (like mapping them to blanks) in the direct copy approach or do I need to read each row and test colA_ISNull TIA, barkingdog There is no way of dealing with them other than testing them for nullability and changing them accordingly. This is easily achieved with a Derived Column component. -Jamie >>>> This i ...Show All

• Jurgita Cannot Install Toolkit.

  Trying to install SQL Everywhere Beta Toolkit. And am getting following error message: "The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade path." On difference is I'm installing on top of the "recently released" verision of VS2005 SP1, not the beta. But, other than that, all ...Show All

• gabegabe ReportExecutionService Render Method - Setting the data - XML

  Hello all, I'm at a bit of a loss as it seems what I want to do should be obvious but I can't seem to locate whether it is possible. Essentially I would like to render a report using the api/C# and I would like to set the actual data the report renders via an XML string that I construct however I like within my code. Is this not possible I hope I'm overlooking the obvious here. Thanks in advance for your feedback. I'm attempting to solve the problem using the suggested sub report method but so far it's not working. I get the following error: Failed to prepare web request for the specified URL. Invalid URI: The URI is empty The instructions say to leave the connection string empty which I'm obviously doing. ...Show All

• laboremus Receive messages from queue based on message_type_name

  I have 2 messages types for a queue and would like to use one application that receives messages of one type from the queue and another application that will receieve messages of a different type from the same queue. Is that possible and if yes how SampK You must send the two message types on separate conversations, to two different services, bound to to different queues. Then you can have one app receive from one queue, the other form the second queue. It is not possible to selectively receive messages based on attributes (type, contract, payload etc) because it could break the order guarantee of the conversations. HTH, ~ Remus ...Show All

• mfindlay Legacy DAO access database to SQL Server 2005

  I have an existing database that was done in access using DAO engine. Need to grab data from this database and insert into a table in a new sql server database. Looking for tutorials or websites on the topic. Seems to be tons of info Sql Server Database Source info. and tutorials, but not much on the Access Data Source. Also is this a good practice or should I just stick with the same database type when working with data, or is it better to get the more robust functionality of a Sql Server Database Source Any help will be greatly appreciated. ...Show All

• Doobe01 implement manual replication between two SQL Server 2005 Express?

  Hi, I need to synchronize the data between two SQL Server 2005 Express. The database is really simple, just few tables (but data are inserted very often) without any triggers. Since Express edition could not behave as a Publisher I was thinking about implementing manually a sort of Replication mechanism... It should be a sort of Transactional Replication with queueud updating. Does it sound a good idea Has anyone done this before o there are better solution Thanks in advance, Stefano I call it the poor man's Log Shipping: a) Backup the transaction log, b) move the backup to a different server, c) restore the log backup on the other server. Do this using scripts. Now, you might be wondering about the res ...Show All

• MShanahan Custom report item

  How would one go about setting the height of a custom report item programmatically   I have a custom report item that renders back an image of indeterminate height.  I cannot simply set RenderItem .Sizing = Image . Sizings .AutoSize;  As the image is being rendered back at 300 dpi and will require being set to FitProportional.  Therefore I need to set the height to a scale height.  I've tried setting CRI.Height to a ReportSize value, but it tells me that I cannot because of the current state of the item. I have also tried setting the Width and Height of the Microsoft.ReportingServices.ReportRendering. Image to the needed values, but that appears to be completely ignored when the report is generated. ...Show All