Hi again,one other problem. I have two SQL Server 2000 instances on an active/active MS Cluster. On one instance jobhistories seem to be cleared automatically every 2 or 3 hours and I am not able to find out where or how to stop this. The number of job history entries seems to be limited to 50 entries as well on […]
2004-02-11
2 reads
It is the drop statement not object_id that is the problem. You will have to use dynamic sql likeSET @SQL='If Object_ID(''NBP'+@yearcount+''') is not NULL Drop View NBP'+@yearcount EXEC(@SQL) SET @SQL='CREATE VIEW NBP'+@yearcount+' AS SELECT * FROM f_customer'+@yearcount EXEC(@SQL)or alternatively use ALTER likeSET @SQL='CREATE ' If Object_ID('NBP'+@yearcount) is not NULL SET @SQL='ALTER ' SET @SQL = […]
2004-01-26
2 reads
One that I would add: The DBA has a duty to protect the data that we are guardians of. We have access to sensitive information, about our company's business, our clients, and even our coworkers. We need to protect it both from being accessed by unauthorized users, and use the utmost discretion in how *we* […]
2004-01-25
1 reads
You will have to convince your Network Administrator that you are following a security policy and that your SQL Server logins are secure. SQL Server has a bad reputation due to the System Administrator account being set up with a blank password, etc.
2004-01-22
2 reads
If the package does not have any versions it may not be in sysdtspackagelog right? I get no records when i run the query.Thanks for your input.
2004-01-22
In a prior post I once wrote:@ http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=19016#bm90510I was wanting to do the same thing some time ago... I realized that Table Function parameters can NOT be values from a "Joined" table. I think is is because the Table Function is meant to return a complete recordset for every call, and a "Join" wants one […]
2004-01-20
1 reads
Thanks for the tip. I'm getting close.I changed it to this and it was still returning Null even thought the record is in there. What I did was remove the ELSE statment and everything after and it worked. What am I missing that it still executes the second part of the statment?Thanks.CREATE PROCEDURE dbo.procAddContactAddress ( @Contact int, […]
2004-01-19
That's exactly backwards advice. Putting the column values in a function makes the predicate non-sargable. Even just converting the values (as your solution also does, implicitly) will prevent the use of any index on the column.
2004-01-12
Already tried rebooting the server -- no luck. Select object_id ('sp_schedule_status_reset') as The_Nasty_One --> (null)
2004-01-12
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers