Search results for query: *

Hey does comptia have a certification for Databases, or anyone else other then Microsoft?? Know the Lord

I took the SQL Server 2000 70-228 test and flopped, the only Microsoft press book I have is the Microsoft press 70-229 seems as though it covers allot of whats on the 70-228 test but not exactly? what do you guys think?? Know the Lord

Has anyone ever used the Ucertify practice test and found those useful in passing the test?? Know the Lord

I was wondering does anyone know anything about having a record retrieved one at a time rather then all of them at once. I have a access xp front end on my database and sql server 2000 as the engine, when you open up the database it opens all the records including the picutres I have on the form...

I was wondering does anyone know anything about having a record retrieved one at a time rather then all of them at once. I have a access xp front end on my database and sql server 2000 as the engine, when you open up the database it opens all the records including the picutres I have on the form...

I am trying to insert pictures into my form, basically when the users open up the forms they see the employee picture as well as the data can anyone help me. Please

Can I use sql server agent to send reports via email to diffent users????

I am getting an error message with the error handling I just added to this stored procedure anyone know why [code]SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE dbo.[SURVEILLANCE-VBM] AS INSERT INTO dbo.GCEmployeeTerms ([TM #], FirstName, LastName...

Hi guys I have been using the 70-228 Sql Administration Measure up practice test, I'm learning from it but I'm wondering if it will help me to pass the test. Transcenders is way to expensive, so I'm using Measure up and Exam Crams also I work in SQL Server 2000 at my job. Any suggestions guys...

need to create a trigger or procedure that will notify users to follow up on a report they produce to other departments after 120 days. The report will be based off the date it was presented to the department "DateRptPresent" and the the 120 days will be calculated off the date it was reviewed...

Hi guys I got a database with SQL server 2000 as the engine and Access Xp on the user end, and when we look up data it takes a little too long. theres a total of 8833 records plus the all the queries and stored procedure in there also. What would you guys suggest I do??

Does anyone know anything about SQL Reporting services, like how much it cost etc..

I need to create a stored procedure that will pop up as a report or whatever. I need it to pop up when the users open up the database, it will show them that a Finding needs to be tended to and until they close this finding is closed out (drop down window) it will continue to pop up. The stored...

I need help bad guys.. I have a combo box that is suppose to find the record on my form according to the value I input. The problem is that it doesnt always work and I dont understand why??? I keep getting an visual basic error message

I need to find out which record I am violating by trying to execute this stored procedure, I am trying to insert the 2004 terms from the TERMINATION table to the Corovan_Table..how do you make a comparison with the two tables?? Code: ALTER PROCEDURE InsertCorovan2004 AS INSERT INTO...

I want to create a dialog box where my users can select what fields they wish to do thier search on, can a cursor assist me in this??

I was wondering about xp_senmail can I send a report with that procedure to different departments. I wanted some information on how to create a stored procedure and have SQL do the emailing for me. Is this possible Private Sub Command165_Click() On Error GoTo Err_Command165_Click Dim...

I created a database that has Access XP on the front end and SQL Server 2000 as the engine. Now I created a view of another table which is located in another database, its called ConditionalLicense_View. It gets updated from time to time from the EmployeeGamingLicense table (after the team...

Some time this year I will be taking the SQL 70-228 certification. What I am using as a study tool is the VTC from SYBEX (MCSE SQL Server Administration VTC) its a practice test, has anyone ever used this before. And does anyone have any tips for me..I really want this certification I dont...

I created a database with Access xp on the front end(ADP) with SQL Server 2000 as the engine. I used the DTS to migrate the data over from and MDB file. Anyway I need to make a homemade Search form for my users....one that they can press a button type in lastname or TM#, FirstName or SSN and...