Search results for query: *

Thank you very much mrdenny. I think I'll work on implemnenting this solution of yours. Mihail

Your SQL server is probably Standard Edition. Standard Edition supports only up to 2 Gb. You need SQL server Enterprise edition to ba able to use more that 2 Gb of available RAM memory Good Luck Mihail

Create a small batch file with this two lines only. net start mssqlserver net stop mssqlserver Create a job to run this batch. This is how I do it Mihail

I have a 120 Gb production databse that I backup and restore onto other server for our internal usage, ad-hoc reports... I am reading about transaction log shipping option, and I was wondering how that exactly works. I backup to disk at 8:00 PM, Backup to SDLT tape at 4:00 AM, and backup...

This is a little something from Microsoft: FIX: SQL Server ODBC Driver Generates Error When Executing a Stored Procedure on SQL Server 2000 Article ID : 286359 Last Review : November 3, 2003 Revision : 3.0 This article was previously published under Q286359 On this Page SYMPTOMS CAUSE...

You can attach the database, or you can restore from backup. If you managed to to get the folder with that database files, than is easier to attach the database files. In EM right-click on datasbases, select all tasks, and then Attach Database. in the srceen that appeares select the location...

I am trying to set up replication between two servers on a single table but it keeps failing on the same place. I am setting up replication on "AGENCY" table. Message is: "Could not find stored procedure 'sp_MSupd_agency'." Is this stored procedure supposed to be created in "distribution"...

Job ID is there in the sysjobs table, but there is no new records in sysjobhistory table in last two weeks since I started having this problem. Mihail

Job history should go into MSDB database into sysjobhistory table. I checked the properties of the agent, its set up not to limet the size of the job history log.. Am am a system adminitrator, and I am using my login id to run the jobs.. I dont know what could be the problem any more Mihail

For the last two weeks or so I can’t get any of the jobs to log the log history. Job executes all right, SQL server log shows that the job finished, but when in Enterprise Manager you right-click to view the job history, that does not work ?!? It does not show that there is any job history for...

As mentioned before you should vreate a group for which you would deny delete. That could be done in a loop sot hat you do not have to go manually through all the 500 tables This is the procedure I created some time ago for that Good luck --****************************** declare @i as int ...

Try this select count(o.*) from Orders o inner join CustomerDetils c on o.CustID = c.CustID where c.PurchaseDate = 'somedate'

this is what you did: c:\b4ins\mssql$b4\binn sqlservr.exe -m and you should have this: c:\b4ins\mssql$b4\binn\sqlservr.exe -m

This is from the t-sql help. Hints go in FROM clause. **************************** FROM Specifies the tables, views, derived tables, and joined tables used in DELETE, SELECT, and UPDATE statements. Syntax [ FROM { < table_source > } [ ,...n ] ] < table_source > ::= table_name [ [ AS ]...

crate proc MyProc as -- you have to declare variables first declare @cond1 as varchar(100),@cond2 as varchar(100) @phrase1 as varchar(100) , @phrase2 as varchar(100) If @Cond1 Then @phrase1 = &quot;Where ID between 1 and 100&quot; Else @phrase1 = &quot;other criteria...&quot; End If...

Below is a procedure I created to go through the whole database, check if a table has a identity column, and disables the identiyu insert on it. I did this for loading data in an empty database. You can do it for an individual table like this: set identity_insert table_name on...

In the Windows Explorer map that server in the network. Than in the Enterprise Manager go to Management, right-klick on the backuip to create new backup device. Hit browse button to serch for the mapped drive .. and that's it. Mihail

Patrik, xp_sendmail works fine, and it's so easy. Thank you very much. Mihail

Patrick2002, Thank you very much. I never used xpsendmail procedure. I'll look it up and if I get it to work I'll post the resolution here. Meanwhile, if someone knows why is CDONTS object not working and how to get it working, post the resolution and it will be greatly appreciated. Tx, Mihail

I should have emphasized which email address is recipient and which one is a sender. Here is the procedure again *************************** DECLARE @result INT DECLARE @object INT DECLARE @propertyvalue VARCHAR(255) PRINT 'Creating the CDONTS.NewMail object' EXEC @result = sp_OACreate...