I have a VB6 application from which I want to create and schedule a jobs. The individual jobs should run once and be deleted when succesfully finished. Almost everything works fine. But enabling the jobschedule won't work. In the sp below I set the @enabled parameter of sp_add_jobschedule to 1 (is also default) which should indicate that the schedule is enabled. How to fix this, or what I am doing wrong? I tried to place an execute sp_update_jobschedule at the end of the sp, but no effect at all.
if multiple days were selected it would use a logical or such as weds and tues = (4+8=12) I am trying reverse get the days back. What is the best to do that. Thanks
I wanted to programmatically create SqlServer JobSchedule The job is to copy data from a particular table in one Database to another table in another DataBaseUser should be able to Schedule/modify Date and Time on which a job is to be executed is to be configured through a UI Screen (WebForm.aspx) I am using VSStudion2003 ,ASP.net with VB.net with SQL2000 as database .
ANY idea on how to do this ????? Please help me? Thank u all in advance
Hi: in sp_add_jobschedule @freq_type = 8 for weekly @freq_interval = 1 for Sunday.
I need to script to create a job which will run every Sunday 6 pm, to backup one prod database to a new backup device. EX. database name is DBTest, and the 7/20/2003 (Sunday) running result should be backup_DBTest_2003_07_20.bak. and next Sunday's should be backup_DBTest_2003_07_27.bak. (if this way, the backup device will be created at the begining of the job running...)
this way the backup would not be overwritten. Is there a way to dynamically generate 54 weeks job script from this coming Sunday?
Or to make the backup result as backup_DBTest_2003_week27.bak, backup_DBTest_2003_week28.bak....
Can anyone tell me what this means and how to fix it? I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error....
use master go sp_configure 'awe enabled',1 go reconfigure go
I got the output, name : awe enabled minimum: 0 Maximum: 1 config_value: 0 run_value: 0
From the value of config_value ,it mean that the "awe" is not enabled.
But, when we see the System Configuration: OS --- Win 2003 Standard sp1
Sql server 2005 sp1 ( I have only one instance )
System configuration = 3.83 GB of RAM
The total is 3.83GB of RAM, but When i right click the sql server instance , select 'Properties' and then on the 'General' tab , i see 'Memory' assigned to that instance as = 3927 (MB)
Does this mean that, someone already has enabled AWE option. That's the reason its showing memory = 3927 MB. (or) i have to enable it externally.
now i have enabled awe in sqlserver 2005.And i set the LOCK PAGE IN MEMORY in group policy.but while i see the sqlserver agent log ,i find that the log shows 4 processor(s) and 4096 MB RAM detected,in fact my server have 8GB RAM.so anyone can help me ?Thanks i have see the sqlserver log ,and find awe enabled
I've looked in several books in addition to the online SQL Server documentation, and I can't find a way to determine whether or not a trigger is enabled or disabled. I know how to enable/disable, I just can't figure out the current status of the trigger. It's not returned in sp_help or sp_helptrigger, and there's no indication in Enterprise Manager of a trigger's status. Does anyone out there know how to do this?
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
When I run surface area config, I select Configuration for Features, but under MSSQLSERVER, I do not see the entry for Database Engine that should have the CLR Integration under it.
Hi, I'm using SQL Server 7.0. I'd like to know if there is anywhere in the information schema or system tables where I can tell that a constraint has been flagged as 'enable constraint for INSERT AND UPDATE' or not.
Hi, I tried to run the following script from SQL2005 server A (publisher) from Database 'TestDB' to SQL2005 server B (subscriber) database 'TestDB' ------------------------------------------- exec sp_addsubscription @publication = N'publish_TestDB_FromCA', @subscriber = N'subscriberTest', @destination_db = N'TestDB', @subscription_type = N'Push', @sync_type = N'automatic', @article = N'all', @update_mode = N'read only', @subscriber_type = 0
with following error:
Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 252 This database is not enabled for publication.
If TCP/IP is the only protocol enabled on the General tab of the Client Network Utility, does it mean that other protocols are disabled and will not be used in communicating to SQL Servers on other machines?
In this case, should the registry HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer ClientSuperSocketNetLib only contain the Tcp entry?
If I have alias setup to use other protocol such as Named Pipes, does it mean that the alias cannot be connected since Named Pipes is not enabled?
Just curious to hear if anyone else has experiences this or knows a reason why it maybe should be this way...
I have some jobs that are disabled accourding to the Job Activity Monitor view in Mgmt Studio. However, if I open the schedules details, this view says Enabled. Can a schedule be enabled for a job, even if the job in itself is disabled maybe? But, I can't see any enable/disable flag in the sysjobschedules table, only in sysjobs.
We are running application on Ms SQL Server connecting to PowerBuilder 7.0.3, using MSS Microsoft SQL Server 6.X driver. We have recently migrated the SQL Server from 2000 to 2005 SP2, in which databases are still at compatability level 80. The application runs perfectly for one week, but later we received some occassional reports from users that database connection breaks after a
certain idle period. Below are the errors, usually error 1 appears before error 2.
Error 1 A database error has occured. Database error code: 10025 Database error message: Select error: Possible network error: Write to SQL Server Failed. General network error. Check your documentation.
Error 2 A database error has occured. Database error code: 10005 Database error message: Select error: DBPROCESS is dead or not enabled.
We couldn't find any related errors in the SQL Server log. Does anyone has the idea of what's wrong or how to trace the connection brokerage?
I am trying to mirror a database and I keep getting the error Msg 1469 saying that "Database mirroring cannot be enabled because the database is an auto close database on one of the partners. Well.. the database properties is saying "false" under auto-close. What else could be wrong?
I've been trying for two days now to get SQL Cache Dependencies to work. So far, nothing has worked, and I have been around the block a few times now on this one. So now I'm going back to basics, as I think my code and queries are fine. My first question is how to confirm that I have a Service Broker that is up and running. I am using SSX as my database engine. Other posts mention how the "look at the service broker folder", and I don't see a folder anywhere. Can someone tell me what to look for? I've added various SP's based on tutorials on web sites, so I can't tell if those SP's are mine or theirs at this point (I've been at this too long). Where is the "folder" the other posts have mentioned? Do I need to do anything special to get it? Did I install all the right files?
I noticed recently that the setting for "Write Cache Enable" for the disk drives is enabled. Can anybody help me out with what is this "Write Cache Enabled" Setting and what might be the consequences of keeping it enabled on a SQL Server production Machine. What performance gains can we have by turning the feature off. Can anybosy please suggest and article for the Same topic
I've Created a DLL Library and added it as an assembly in a database when I make a select statement from SQLCmd using my functions it runs fine but when I try to Create View from the VB 2005 Express Development Environment it Gives me the Error
SQL Execution Error Error Message: Execution of user code in the .net Framework is disabled. Enable "clr Enabled" configurartion option
note that CLR Integration Option of the SQL server is ON and I've Tried sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'clr enabled', 1; GO RECONFIGUREform SQLCMD in vainwhen I execute the select statement from the SQLcmd it runs fine but when I try to make a View from the Developmet Environment i gives me that error Please Help
I'm using bcp and sqlcmd against SQL 2005 engine. They both work fine for long periods of time, but every few days they stop working with an error something like this:
A connection could not be establed - actively refused - this might be because remote connections are not allowed or the named pipes protocol is not enabled.
The thing is, remote connections ARE allowed, and named pipes ARE enabled. I have to recycle the SQL serverice to make it start working again.
I am getting a reference problem in APP_Code when I am creaing LinQ enabled website. When I am creating LinQ enabled website at that time it adds some dll like System.Query, System.Data.DLinq, System.Xml.XLinq and in web.config file it adds <system.codedom> <compilers> <compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CSharp.CSharp3CodeProvider, CSharp3CodeDomProvider"/> </compilers> </system.codedom> automatically. Now the problem is when I add references like System.Query it does not show the Query namespace (It does not show any of the external dll added in the bin folder). And if we comment the <system.codedom> <compilers> <compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CSharp.CSharp3CodeProvider, CSharp3CodeDomProvider"/> </compilers> </system.codedom> in web.config file it works properly that means it shows System.Query and other refrences. Please if there is any solution do reply, Thank You..
Hello I am using I created sqldata source, tables and also a gridview. I am using sql server express with prof VS 05. I CANNOT USE the executable aspnet_regiis.exe on SQL server express.( you need the full version) I get the error"Debugging failed because integrated windows authentication is not enabled"
I´m trying to enable full-text indexing in SQL Server Management Express 2005. I can see the option is there (Database name - Properties - Files), but the options is blurred and I´m not able to select it. How do I solve this problem? Getting desperate trying now...
I am unable to access the default port 1433 on my SQL 2003 server. There is no firewall. I run telnet <ip> <port> and get "Connection failed" which explains my inability to connect to the server for weeks. I have being unable to connect to the server after I uninstalled sql 2000 and reinstalled it on my 2003 server. Some of the things I have checked is Network Configuration in EM. Named Pipes and TCP/IP is installed with port set to 1433. HKLMSoftwareMicrosoftMSSQLServerClientSuperSocketNetLibTcpDefaultPort port is set to 1433. Is there anything I need to configure on the server side to have the default sql server port enabled.
We have bulk copy option enabled for our DB and we really use it. Will it be possible to set up a snapshot replication over the Internet of particular tables to a remote server from which the data will be only retrieved and never changed? Also, is it necessary to have PKs in all tables for this one-way snapshot replication? (for transactional replication it is needed, as I know)
I am trying to get a MS Access Database to work on my companies intranet. Everything works fine on my laptop with local file paths. After transferring the files to the web server and changing file paths, I get the 2 following errors.
"Data provider could not be initialized" "Not a valid file name"
I assume that I am having a problem relinking the database, but unsure of how to do this.
Hi, I'm having trouble with some SQL. I have a document table which links to a document version table. I'd like to write a query to get the latest enabled version of every document - a resultset with one row per document. Is this possible with resorting to a cursor?
CREATE TABLE tblDoc ( DocId int ) GO
CREATE TABLE tblDocVersion ( DocVersionId int, DocId int, DateCreated datetime, IsEnabled bit ) GO
INSERT INTO tblDoc (DocId) VALUES (1) INSERT INTO tblDoc (DocId) VALUES (2)