Search results for query: *

You probably need to do the sp_stop_job, as well as the sp_update_job.

Please define "another database". Another SQL Server, or do you mean another DBMS, such as Oracle, MySQL, etc. If you mean another SQL Server (SQL2000), you can use DTS to do the job. If some other flavor of db, then it gets more involved.

Try these query examples, which assumes that the LDAP (AD) server has been appropriately configured as a SQL linked server: -- select from Sun iPlanet select top 100 * from OPENQUERY(LDAP_Server,'SELECT UserID, UserStatus FROM ''LDAP://ldapserver:389/dc=org1,dc=org2'' WHERE...

Using Enterprise Manager, I would use a DTS package for this, but it will still need to be tweaked each time to point to the new target database.

Another convoluted approach would be to establish a linked server definition back to itself (the same server). Then you can do an OPENQUERY to run your sp. The mainline query will them treat the sp results as a temp table, to which you can JOIN, as necessary. However, I wouldn't do this with...

declare @sql varchar(255) set @sql = 'SELECT * INTO MYTABLE' + convert(char(4),DATEPART ( yyyy , GETDATE() )) + RIGHT('00'+convert(varchar(4),DATEPART ( mm , GETDATE() )),2) + RIGHT('00'+convert(varchar(4),DATEPART ( dd , GETDATE() )),2) + ' FROM MASTERFILE' exec @sql

You would use "Execute SQL Task" and specify the sp as follows: EXEC userschema.mystoredproc

How about: begin transaction UPDATE reminder SET reminder.mycolumn = SOT.mycolumn, .... FROM reminder INNER JOIN someothertable SOT ON reminder.matchup_col1 = SOT.matchup_col1 AND reminder.matchup_col2 = SOT.matchup_col2 ... where SOT.status = 'open' INSERT INTO reminder(mycolumn, ....)...

Assuming the 2 db's are on the same SQL server: select P.Prjcode, A.prjcode from DB1..tblPrj P inner join DB2..prjAccts A on P.Prjcode = A.prjcode

Do you mean something like: exec sp_help myproc

How about: select sum(i.vchUser3) + sum(i.vchUser5) + sum(i.vchUser6) + sum(i.vchUser7) as total_all from dbo.Incident i

SELECT CASE WHEN ISNUMERIC(Code) = 0 THEN CONVERT(int,Left(Code,4)) ELSE CONVERT(int,Code) END AS Test, SUM(amount) FROM test_search GROUP BY CASE WHEN ISNUMERIC(Code) = 0 THEN CONVERT(int,Left(Code,4)) ELSE CONVERT(int,Code) END

Also, DTS can be run from command line as: dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage_password Also, see MSDN library article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtsrun_95kp.asp

Try this MSDN library article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_3vqr.asp

There are fundamentally 2 ways to accomplish this, and it looks like you have attempted to use both approaches at once. The preferred (newer) method is : select T1.* from Table1 T1 left outer join Table2 T2 on T1.[ID] = T2.[ID] where T1.[ID] is not null and T2.[ID] is null The older...

I believe you have 2 choices: (1) DECLARE @mycol int SET @mycol = 5 SELECT TOP 20 CASE @mycol WHEN 1 THEN Col001 WHEN 2 THEN Col002 WHEN 3 THEN Col003 WHEN 4 THEN Col004 ELSE Col005 END AS mycol FROM mytable OR (2) DECLARE @mycol int SET @mycol = 5 DECLARE @sql varchar(255) SET...

You may want to check whether you are allowing nested triggers, using: EXECUTE sp_dboption 'myDB', 'recursive triggers' As described in BOL, you can add 'TRUE' or 'FALSE' to the above statement, to alter your current setting. This may not be the issue here, but it's worth testing.

....And, you can leverage it, in your sp, like this.... SELECT T.* FROM myTable T INNER JOIN fn_Split('1,2,3,4,5,6', ',') AS Q ON T.[ID] = Q.value

If you are using SQL2000, you could also setup a user-defined function, as described at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/TreatYourself.asp

If you are describing locking problems, particularly deadlocks, you may not need to resort to a trace (SQL profiler), although this can also be a useful tool. Other tools would be Enterprise Manager (under Management/Current Activity), sp_who, sp_who2, and DBCC INPUTBUFFER. You will need to...