Using MS SQL Server

sql agent JOB to Backup Database and Maintain Backup Files
Hi friends, How can I create ONE SQL Agent JOB That will 2 activities: (Using SQL 2005) 1) Backup a specified Database (Full Backup) and store the backup file in a Specified FOLDER. 2) Manage the Backup Files in the FOLDER, ie. Delete the files that are 5 week OLD. I want to schedule the JOB to run every S... 30 Jun 2008 16:51

Need a script to recreate scheduled jobs
I created a new database instance, but I forgot to script out the scheduled jobs before I wiped out the original database instance. I have attached the original msdb database as msdb_old onto the new instance, but I need a script to pull out the require information from sysjobs, etc. to recreate the jobs. Ple... 30 Jun 2008 18:55

Help needed for Data formatting.
Hello all, I just started using SQL to create a report. I got the syntax working but I have absolutely no idea of how to format data. Can anyone kindly look at my code and help me? I thank you in advance. Details:- The code: SELECT Column1, Column2, Column3 FROM WORKSHEET Output: Column 1 Colu... 30 Jun 2008 16:51

How can I do that using a trigger
Hi! I've got a table where an index number is already given. I want to establish a trigger on a tmp table, so each time rows are inserted, the trigger verify the next number available in the main table, and then update it. I've tried this: ----------------------------------------------------------------... 30 Jun 2008 18:55

OLEDB configuration when deploying multiple SSIS packages
I have an SSIS package which calls many other SSIS packages. Each of these was created with the import wizard in SSMS. As a result, they all have SourceConnectionOLEDB and DestinationConnectionOLEDB connections listed under the Connection Manager in the package designer. T deploy the packages to another server... 30 Jun 2008 13:45

Decimal point and comma
I 'd like to insert (via "bulk insert") between 10-20 files (about 300MB each) into one table. The problem is that in input files decimal point is written as "," and without leading zeros (i.e.: ",45"), and sever uses ".". So I 've got an "type mismatch" error. I can't re-build input file, as well as I can't c... 30 Jun 2008 18:55

Stop hotlinking to a specific file & keeping a counter
Sinikeltainen linja romahtaa. �gestan ruotsalaisydinvoimala osoittautui valmistuessaan 1963 jo vanhentuneeksi. Tuottaen ydintyyliin 3 milj kruunua tappiota. Vaivasi itsepintaiset s�teilyvuodot. 1974 suljettiin ensimm�isen� ruotsalaisena ydinvoimahylkyn�.(Vaan ei toki viimeisen�!)) My�s Marvinke-hanke raskasves... 29 Jun 2008 01:57

Please Help - Can't check for duplicates
I'm driving myself crazy with a problem in trying to translate a query written for Access to that for SQL server. I would think that I would use a trigger, but am not sure how to set it up. We have a database that manages bookings in four banquet halls. It was running in an Access database, but two years ago... 30 Jun 2008 02:28

Deploying an app with SQL Server (installation on client machine)
I have an app that will be using SSE as the backend database. My app consists of several executables and libraries, I need to bundle all of them together with SSE. Ideally, I would like to provide a single installation file that installs my program, and also the SSE database. Any links/instructions/advice on... 27 Jun 2008 12:08

How to secure a database ...?
I am writing an application which I will deploy to my clients. It is important for security, support, IP reasons etc, that the users are not able to access my databse schema (i.e. view/modify/run procs etc). What do I have to do to ensure that users will not be able to access my database? Also, I am thinkin... 28 Jun 2008 08:36