Search results for query: *

Freakin wow.... George that worked perfectly for what I need to accomplish!!!!!!

Wow thanks for the quick replies: I decided to go with declaring the variable first and im kinda lost as to where i insert my code, this is what I have currently: ----------------------------------------------------------- DECLARE @n varchar(100) set @n = oe_hdr.delivery_instructions SELECT...

I am looking to format a field in my view that does the following: If I have a field that looks like this --------------------------------------------------- pay to customer #123456 freight code 0 ---------------------------------------------------- name of field: oe_hdr.delivery_instructions...

I am trying to create a seperate GPO for my Terminal Servers so that the user cannot change the enviorment. I found this tutorial but when I go to see if the changes were implemented ... alas they are not. This is what I have done.... I set up a seperate OU and under that i put a new GPO...

I love the web resourse: http://www.mssqlcity.com http://www.justphukit.com/sql/sql-tutorials-1.php My new two favorite sites, Thanks for all the help guys, I will be writing in no time :)

Wow both of those books are at my local library..... nice Yeah I will be running an enterprise business solution for my company so I probably will be using some pretty heave SQL for my work. I will be getting these beautys today

I have been forced (as the only IT guy in my company) to learn SQL for database admin reasons. I guess I dont have a back background in sql... some college classes but I dont have near the experience to create views, triggers and what not to the level I need. Can some of you uber guru's help a...

Yeah im reading about all the steps for getting non-profit tax exemption and I realize im a nub when it comes to that kind of stuff. I checked with a local gov agency and they offered to provide a small amount of free legal advice but that paperwork is DEEP Looks like I will be hittin up my...

I have currently been working on a business plan to complement my idea and what-not. The problem im having is the dang financials?? Im really bad at that kind of stuff. Im hoping to recruit and accountant that might be able to help me understand some of the more complicated issues. But there...

From what i have been researching the non-profit arena seems to be complex and difficult via tax and income reasons. I realize now that just a dream and alittle knowlegde doesnt = success. From what ive been told I will need a lawyer for filing the initial paperwork. I like to idea of having...

I am currently in the Denver area and I volunteer alot. I currently have my CCNA and MIS. Throughout my travels I have found that the non-profits get the worst support ever. I mean along the lines of we will set it up then its up to you to keep it runnings. Now I know that most cant pay for any...

ok out of single user mode but same errors... I tried sp_who2 but to no avail, there are currently no connections to the db that I would like to restore ???? Says the problem connection is the current session that im using but im not connected through that db either .... WTF??? ...

I ran sp_who2 and I could not find anything that was connected to the database I am trying to restore to. And i mean not a singe process, I switched my default db to master and still no sucess Im stumped... But on a different note.. I cant get out of single user mode lol... Bonkers

My initial message was this: System.Data.SqlClient.sqlError: REStORE cannot process database because it is in use by this session. Use master I checked and nobody is logged into the database. I removed the session from the DB by choosing to run in master but to no avail.. (same error message)...