Variuous ways of deleting Job history and deleting the job history log files from the folder

All, when we create a job via the maintenance plan, we have the option of including "Clean up History" and "Maintenance Cleanup Task". Via the "Clean up History" task, we normally specify how far back we want to maintain the history (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_5techref/html/cd6f7033-b762-453a-ae42-f36d8073c0b2.htm) declare @dt datetime select @dt = cast(N'2010-08-08T10:22:37' as datetime) exec msdb.dbo.sp_delete_backuphistory @dt GO EXEC msdb.dbo.sp_purge_jobhistory @oldest_date='2010-08-08T10:22:37' GO EXECUTE msdb..sp_maintplan_delete_log null,null,'20

Database State OFFLINE

All, I want to understand the OFFLINE database state better. Suppose, if I want to move a database to another drive after the executing "ALTER DATABASE A SET OFFLINE" and copying the files to another location, how would I set the database to ONLINE. "ALTER DATABASE A SET ONLINE" would not work since the system will not know where the data files are now located. rgn <<OFFLINE Database is unavailable. A database becomes offline by explicit user action and remains offline until additional user action is taken. For example, the database may be taken offline in order to

Cant use Import-Module in Powershell in SQL Server 2008 SQL Agent

Yo Geeks, SQL 2008 SP1 CU 5 Enterprise x64 Windows Server 2008 R2 Datacenter Wrote a basic Powershell script to get Membership of Certains Groups from AD using the ActiveDirectory Module new in 2008 r2/ Windows , and insert into a SQL table required for some old dodgy app. Tested outside of SQL Agent - all fine. Want to use as SQL Agent Job / Powershell step. Created a job and got message like "Import-Module is invalid command" Thought SQL might be running Powershell 1.0 , but $Host run from SQL Agent says 2.0 From same SQL Agent job do a "Get-Command" and myste

RE-Raiserror in error handler procedure

Hi NG, I have a store procedure which is my error handler. In each catch- block of a try/catch a call this function for error analization. Now in some cases I would like to re-raise the same error from this hanlder. But then I have a error number 50000 instead of the root error number. In my outer Try/catch I would like to see the root-error. Is this possible (like throw with same parameters in C#) Thanks Marcel

dealing with invalid dates

Hi, Is there a way to deal with invalid dates during a select? Currently I'm getting dates in a column in this format: 20100726 (yyyy/mm/dd) I need to display it as 07/26/2010, so i was using this: SELECT CONVERT(VARCHAR(10), CONVERT(datetime, startDate, 101), 101) problem is startDate at times in not a valid date, sometimes there is just a 9 or another digit there that is not a valid date, is there anyway to check aganist that? Thanks.

Sql Server Version # from dfb file

Hi all, Q1: Is there a way to tell what version number a dbf file is? Q2: Where can I find a list of version #'s, ex, 621 = SQL 2005 Background: Using VS2005 and VS2010 with SQL Server 2005 Express. Somehow the DB on the production server got updgraded. It works fine on the server but the production boxs cannot open the db. Message says: (paraphrased) cannot open db ver 661, server is running 655. So the db file on the server is 661 and the production box is running 655. I added SQL 2008 R2 to the production box and can now open the db, but I want to have the abili

Varbinary(Max) Data compression

I need to compress hudge files (PDF + TIFF) stored in a varbinary field. I found in BOL that :" Because of their size, large-value data types are sometimes stored separately from the normal row data on special purpose pages. Data compression is not available for the data that is stored separately." How do I compress those fields?

Trapping losing commands

In our applications once in a while the commands don't get through to the SQL Server for different reasons. Since it is an automatic process there is nobody in the front end to rerun those command, and they are getting lost. The rezones for the lost could be: Time out, broken connections, Deadlocks ect. Is there a way SQL can trap these and replay them?

Small DBMS

I'm looking for a small DBMS to hold one data table with 10 columns (one of them is the data - varchar(max) avg is 1000 chars) and another few reference code tables. The data table has ~1M recs. The DBMS is to be installed on the application CD. The application is to search a record on the table by diffrent properties (the 10 columns on the data tabe) and return 1 record. The installation on the application disk has to be free (10K CDs are to be in the first version) Which DBMS would be good? MySql? Sql Express? XML file?

Overwrite Master Db

Hi all, I have a question about Master db in a DR environment. Our customer has follow environment setup: Live Site: SQL Server 2008 Standard DR site: SQL Server 2008 Standard Both share a SAN disk so that if the Live site is down, the DR site will pick up all database request. But as the customer install both SQL server instances databases onto the SAN disk, it means the Live Master DB will overwrite the DR Master DB every time they sync the user databases on the SAN disks. How can I avoid this happen? Cheers,

laying out iscsi drives for SQL

Is there a best practice for laying out a disk structure on a Windows Target server for an SQL server initiator's drives? Point being, when configuring the drives on the iSCSI Host, you format them as the VHD, then should you format the drives the same way as on the initiator, in this case an 2008 SQL server? We have formatted the drives on the iSCSI host with default settings, and then on the initiator, our SQL server, we format the drives with a 64K allocation size. We are trying to determine the optimal size of formatting the disks. Should both servers’ drives be formatted w

Shrink transsaction log file

I try to shrink the transaction log file. I made a back-up of transaction log and after that from context menu->Tasks->Shrink->Files->Transaction Log-> Release unused space (there is 92% unused space). After all this steps, the file keeps the same size. Why? Nick __________ Information from ESET NOD32 Antivirus, version of virus signature database 5400 (20100826) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com

Linked Servers

I would like to create two linked servers to the same data source. The first linked server has fairly open access to the database. The second linked server will have limited access to the database (readonly on one view). The two Linked Servers would be configured to access the database through different logins on the source server with different access to the same database. The first Linked Server works fine. I can't seem to configure a second linked server to the same datasource, even if I define the Server type as another data source. How can I create two linked serve

convert(binary(4), @Number) not giving expected result

Hi I thought the following code would give me a result of 1101 bit instead it gave me 0x00000000D. declare @Number int set @Number = 13 select convert(binary(4), @Number) select cast(@Number as binary(4)) What I wan to do is convert a integer or number to binary. (2s Compliment) Background. I am doing this because we use BPay at work but finance uses it for invoices that can be for more thatn on thing. I.E our customers pay thier Joining fee and then choose to pay for other courses, groups etc. But with BPay you get only one reference number and one amount. So what I

Multiple backups with datetime stamp

I want to backup multiple Databases on Daily biases and create a file for each Database. I would like the backups to have datetime stamp. I was going to use either Differential or incremental but I don't know the best solution. I would be grateful for your suggestions. Thank you in advance.

How to use datepart in below scenario

Hi Guys, I have the following dates: 8/23/2010 6:30:00 AM 8/24/2010 6:29:00 AM 8/25/2010 7:00:00 AM 8/26/2010 5:00:00 AM 8/23/2010 6:30:00 AM/ is Monday but i want to treat also 8/24/2010 6:29:00 AM as Monday. Scenario: production schedule is from 6:30 am to 6:29 am the next day. how can i use selec case? i am using sql server 2005? Thanks and regards, george -- Message posted via http://www.sqlmonster.com

mercedes das xentry full verison rapidshare vc<X#&@JPO

We can crack or emulate any protection type: Dongle, Hardlock, Hasp, Serial, Password, Hasp4, Flexlm, Sentinel, Wibu, Eutron Smartkey, Hasphl, Proteq, All the Protections!! email = yshowsoft@gmail.com email = yshowsoft at gmail.com NEW UPDATES 2010 Artpro 9.5r4 with license (minimal of 2 license) Oris Press Matcher fiery impose Fiery Color Profiler 2 Preps 6.0r3 Dynagram Dynastrip v6.0.1 Dynagram inpO2 Artpro 9.0r8 (all modules included) Esko Visualizer 7.5.5 Esko Softwares Suite V7.5 PC/Mac Trueflow SE6.0.1 with SPM fully crack Heidelberg SignaStation v4.5.10.91

Inherited column collation

Hi, Just to clarify, my understanding is that all column collations are hardcoded and there is no inheritance structure. Is this correct, or does SQL know internally whether collation is inherited from the database default or whether it was explicitly specified for the column? i.e. one column is created using COLLATE database_default, one column doesn't specify a collation during creation and one column is created using COLLATE Latin1_General_CI_AS (which is the default database). Is there any way to tell them apart? Does it make any difference to the schema? Sorry to ask but

Famous Software ftp download 2011!!.

Famous Software ftp download 2011!!. anwer8@nextmail.ru Anything you need,You can also check my website: ctrl + f http://famous-software-ftp-download-2011-a.962857.n3.nabble.com/ http://aswer8.wordpress.com/2010/08/02/famous-software-ftp-download-2011 b/ COADE.PVElite.V2008 & V2007 COADE.PVElite.V2010 & V2009 COADE.Worx Pipe 3.1 COADE CAESAR II 5.1 COADE.CAESAR.II.v5.2 COADE_TANK_V3.10 COADE_CADWORX_DATASHEETS_V2010 COADE_cadworx.equipment.V2009 Coade CADWorx Equipment v2010 COADE_CADWORX_IP_V2010 COADE CADWORX_PIPE2004 Coade CADWorx Plant 2010 Coade CADWorx P

Failed to backup

Hi, I have SS 2005 9.0.3228 (SP2 ??) this server is a publisher for merge replication every 5 or 10 min there are about 100 subscribers. Is it too much ?? I can't backup my server (OS backup with Netbackup) How I can do my OS backup (skip some files ???) Thanks for your help

sql 2008 data compression

We are thinking of running compression on our databases now that we moved over to SQL 2008 ? Our databases are quite huge and was wondering, how long does it take to compress ? I guess the answer is it depends.. but would be curious to get some examples of times. Also, is it an offline operation .. meaning the table(s) cant be accessed when the operation is running ? Thanks

Installing on Win7

My computer is running on Windows 7 with Visual Studio 2008 Sp1 and .Net 3.5 sp1 I am not able to MS SQL 2008 and getting compatibility issue error and says it requires .Net 3.5 to be installed Any workarounds?! Regards Raj

bulk air force ones for sell

http://www.24hours-buy.com/ wholesale discount nike air force one shoes http://www.24hours-buy.com/ cheapest nike air max90 shoes nike maxltd shoes http://www.24hours-buy.com/ cheap gucci sneakers,prada sneakers http://www.24hours-buy.com/ cheap jordan sneakers http://www.24hours-buy.com/ nike shoes wholesale in china http://www.24hours-buy.com/ discount chanel gucci shoes wholesale http://www.24hours-buy.com/ jordan sneakers http://www.24hours-buy.com/ cheapest puma sneakers wholesale http://www.24hours-buy.com/ dsquared2 shoes wholesale in china http://www.24hours-buy.com

Extract month form a datetime field

Hi, something else: I want to show in a view, the month of a date as fixed format = "00" Thanks again LAM

partition or archive

What is the difference between partitioning a table and archiveing a table in sql server 2008?