Recent content by modglin

We have certifications for managers that consist of several classes. We have a DTS package that compares the Certcode for the manager and if they equal a particular code it inserts the appropriate classes needed to complete the certification. Once they have completed all the courses, the...

Thanks - forgot to change the new database to simple! That helped that one. The original databae is simple and still has the issues that it has. We are working with the company that created the program, however, they are saying it is our system that is the problem not their program. Funny -...

We have a canned program that recently went to SQL. They apparently did not do a good job of indexing everything before and it definately did not get any better. They even separated out the indexes in the database so we have Program.mdf (28 gb)Program_indexes.mdf (21 gb) and Program_log.ldf...

ok - how do you apply it to SSMS? I was going to do a repair on the installation to see if it gave SSMS as an option and did not see that. Sorry didn't find anything specific on their website.

After installing SP2, I have been having problems using the SQL Server Management Studio = Job Activity Monitor. If I try to add a job or ran an existing job manually I receive the following error: Could not load type 'Microsoft.SqlServer.Management.SMO.Agent.JobBaseCollection' from Assembly...

synapsevampire - finally getting a chance to let you know - The user actually liked the report with the subreport moved to the group rather than on the detail line (Different day, different preference on layout for the user) Anyway, with the formulas that you provided and moving the subreport...

synapsevampire - I knew I would forget something in the post! The sub is actually on the detail line rather than in the header. I'm thinking that is actually part of my problem (everything else that I have done with shared variables were in the groups instead) If need be I can create another...

I have a report that is using a table that contains classes taken by the employees and then a subreport in that report that uses a table that has certification that the employees have. On the subreport - I have the expiration date of the employee certifications. On the detail line I have a...

We have a 32 bit x86 based computer. It has 4g RAM and 5 drives c: has 33g with 10g free, the others have 136g with 39 to 76 g free. I ran the script you sent and the run value is 0 however, after contacting Microsoft - I ran the Hotfix 2187...

We are having problems with a Sharepoint database. When someone trys to upload anything bigger than 1 meg we get an error message in the event log Event ID 17052 Error 17803, Severity 20, State 12, Insufficient memory available. We have over 34 g left on the drive where the ldf file stored...

Thanks Everyone! I forget that SQL is case not if. Been using Access and Crystal and trying to learn SQL. I would have caught the fact that it needed to be ('220','221',etc) based on the Crystal reports, but good catch if someone else refers to this post!!!! I created that view and then...

I have 3 tables that I would like to use to create a view. I may not be able to bring the third table in and that would be okay, but it would be nice to have all the information in a view for another department to use. I want all employees that are active from the second table. The first...

none of those worked. I had someone recommend entering sqlcmd -S . -E and the rest of it and leave out the localhost or whatever I was typing in for the instance. He explained the . means local. That worked. Or at least it got me past that error. Now I have to determine some permission...

Thanks - did that and it shows SQL Server(MSSQLSERVER) I tried typing part of the command sqlcmd -S .\%mssqlserver% and I received the same error message as before.

I am trying to run a dos command to populate a database in 2005. When I installed SQL2005 I took all the default prompts. I later changed the connections to Allow Remote Connections to this server. The command that I am supposed to run is sqlcmd -S .\%INSTANCENAME% -E -d %DBNAME% -i...