Satya, I will try this when I get to work on Monday and get back to you with my results. Thanks for the help
Hello, I have goggled a couple different methods for importing using t-sql and found this one to suit my needs. However I am having some trouble. My...
Rohit, I knew that going into it but after reading how people with the same setup as mine successfully installed it, I was determined to do the...
You are right I have not installed the services this is because, the Server Components are disabled (grayed out). Only the last item (Client Tools &...
I am not able to connect using the machines hostname. I have verified that SQL Server Service is not running. I also went under Administrative tools...
Hello, I am running sql server 2005 enterprise on 32 bit vista ultimate. I went through the process of enabeling IIS, installing sql server 2005 and...
I found this page to be very helpful when i was having trouble configuring the email. http://msdn.microsoft.com/en-us/library/ms187540(SQL.90).aspx...
WOW im such a doof all i had to do was put the ORDER BY outside of the select like this. thanks for the advice though DECLARE @tableHTML...
Hello all, I am trying to set up an email alert which orders the table by PointDateSRC01 then takes the top 7 rows and returns them in an HTML...
FrankKalis, I want to stay clear of altering the data in the AgentAddresses table. Someone actually helped me with this by applying the following...
Greetings, I am trying to join two tables AgentAddresses and ZipCodes on a field called zipcode in to create another table named Agents however...
Hello All again, Back with another question. I am looking for off-site archiving. Here are the requirements Currently the server has 2 TB of data...
moh_hassan20, For now the problem is resolved. I still have some further investigation to do. I will post again once I have finished, thanks
moh_hassan20, Thank you for pointing that out with the logic behind it. I also found another error. Instead of using LIKE I should be using IN and I...
I tried that and also tried having BEGIN END statements for each of the IF statements however that did not change the returned results. I think my...
Hello all, I have this sp that is being used to generate an number of agents by distance from the inputted zip code. It worked fine until i had to...
Hello All, I am trying to create a complex case statement which involves validating a zipcode (meaning it has to start with either a 3,7, or 8 and...
I had the same question a couple of weeks ago and after doing some research I came across this website which prove to be useful....
thanks for the help. much appreciated
Hi all, I am trying to create a script named script_H_v.1.0 that generates all objects in the database named Reporting_H .I havedone this before many...
Separate names with a comma.
