determiningsecurity.blogspot.com
Determining Security: Determine when currently executed job started
http://determiningsecurity.blogspot.com/2012/03/determine-when-currently-executed-job.html
Thursday, March 29, 2012. Determine when currently executed job started. I am trying to determine whether currently executed job is taking longer. Than usual. I was wondering whether there is a way to determine start time. Of currently executed job. I can use sp help job or xp sqlagent enum jobs. But none of them reports this information. Any advice is greatly appreciated,. Query the MSDB.sysjobschedules table for below fields:-. Imarchenko" igormarchenko@.hotmail.com wrote in message. News:e8XavO6lFHA&#...
tablesinadb.blogspot.com
SQL,tables in a DB: (NOLOCK) and Linked Servers
http://tablesinadb.blogspot.com/2012/03/nolock-and-linked-servers.html
Sunday, March 25, 2012. NOLOCK) and Linked Servers. I know that you cant have an optimizer hint when running an ad-hoc query. From another server. My question is why? What prevents it from using the. Message posted via droptable.com. Http:/ www.droptable.com/Uwe/Forums.erver/200509/1. Use the OPENQUERY function instead of the 4 part name. PButler via droptable.com" forum@.droptable.com wrote in message. News:54C0F66FA391C@.droptable.com. From another server. My question is why? Thank you Jerry,. Message ...
sqlrowcount.blogspot.com
sql rowcount: _WA_ entries in sysindexes
http://sqlrowcount.blogspot.com/2012/03/wa-entries-in-sysindexes_22.html
Thursday, March 22, 2012. WA entries in sysindexes. When I look at sysindexes, there are lot of WA % entries in there for my. Database. These are constraints I believe, created by checking 'Auto create. Statistics' option at the DB level. SOmewhere I read that if you see lot of. These constraints, it is better to create 'em as permanent indexes for better. 1) Is that true? 2) How do I extract the ddl for these constraints? KNM When I look at sysindexes, there are lot of WA % entries in there for my.
sqlsqlexpress.blogspot.com
SQL SQLExpress: March 2012
http://sqlsqlexpress.blogspot.com/2012_03_01_archive.html
Tuesday, March 27, 2012. Identity not returning Value. I have a stored procedure that inserts a record. I call the @.@.Identity variable and assign that to a variable in my SQL statement in my asp.net page. That all worked fine when i did it just like that. Now I'm using a new stored procedure that inserts records into 3 tables successively, and the value of the @.@.Identity field is no longer being returned. Anyone have any ideas? CREATE PROCEDURE [iguser].[newticket]. 64;Category nvarchar(80),. Fixed t...
sqlrowcount.blogspot.com
sql rowcount: _WA Statistics Error
http://sqlrowcount.blogspot.com/2012/03/wa-statistics-error.html
Thursday, March 22, 2012. We have had a problem with a table recently where a load had stopped half. With through with an index problem. After a bit of delving the problem seems to be causes by the system created. Statisitcs for a particial index or at least thats where the error message is. The database is set to auto update the statistics and we use this table to. Do a lot of loads, truncates and deletes. My question is this, has anyone seen a problem created by the System created. WA entries in sysind...
sqlerrors.blogspot.com
sql error: "Version 2.0 Is Not A Compatible Version"
http://sqlerrors.blogspot.com/2012/03/version-20-is-not-compatible-version.html
Monday, March 19, 2012. Version 2.0 Is Not A Compatible Version". When using VS2003 and Reporting Services 2005, I am met with the following. Compilation error after creating a dataset then trying to design it:. Version 2.0 Is Not A Compatible Version". I cant drag any tools to the design surface, or add any fields. I have both. SQL Server 2000 Reporting Services as well as 2005. Anyone have a hint on how I can remedy this? Here is the stack:. Exception Text * * * * * * *. CaItem, Type caType). At Micros...
sqlerrors.blogspot.com
sql error: "unable to load MDT2G.DLL" (sql 7.0)?
http://sqlerrors.blogspot.com/2012/03/unable-to-load-mdt2gdll-sql-70.html
Monday, March 19, 2012. Unable to load MDT2G.DLL" (sql 7.0)? I'm using sql server 7.0 - on "SQL Server Enterprise Manager" screen,. When I right click a table and select "Design Table" on the menu list,. I get error message box "Unable to load MDT2G.DLL". I never had this before and don't know what happend. What caused this and how to fix it? I'm using sql server 7.0 - on "SQL Server Enterprise Manager". Screen, when I right click a table and select "Design Table" on. What caused this and how to fix it?
sqlrowcount.blogspot.com
sql rowcount: _wcsupr () with german characters
http://sqlrowcount.blogspot.com/2012/03/wcsupr-with-german-characters_333.html
Thursday, March 22, 2012. Wcsupr () with german characters. I have a string which contains some german characters e.g 'Menü'. I. Am converting it to upper case using wcsupr (). But ü is not converted to Ü. There are other characters too. I can use the wsetlocale () function before. Using wcsupr (). I cannot use the current machines locale setting. The. Strings have to be converted to upper case based on the locale of the target. The string to upper case considering the language specific characters. I.
sqlerrors.blogspot.com
sql error: "View Report" button.
http://sqlerrors.blogspot.com/2012/03/view-report-button.html
Monday, March 19, 2012. Would someone be able to tell me if this is a bug or not. When I have two. Parameters (both text boxes) and change the first one and click on the "View. Report" button to refresh the data with the new parameter values it blanks. The report out and I do not see "processing report" like I normally do. On. The second click it processes the report. When I change a parameter in the second text box and click "View Report", it. Processes the first click. Happy to provide the RDL. Paramet...
sqlerrors.blogspot.com
sql error: "UAT" Managed test Post
http://sqlerrors.blogspot.com/2012/03/uat-managed-test-post.html
Monday, March 19, 2012. UAT" Managed test Post. Using johnogorman@.netscape.net ACCT. Your display name is strange in that it doesnt seem to map to your email. Address, but thats just a guess. If this was a test to see if youre coming. In as a "managed" customer, however, I can confirm that. :-). This posting is provided "AS IS" with no warranties, and confers no rights. Vikrant" johnogorman@.netscape.net wrote in message. News:uMQSgXrMEHA.3556@.TK2MSFTNGP09.phx.gbl. Subscribe to: Post Comments (Atom).
