Programming SQL
in [Microsoft SQL Server]
|
SQL logs Hi, i have at the moment in SQL 2005 a period of time when processes lock and slow down a back office system, but when reported they seem to disappear. What i am asking is that from the logs in SQL Server can i trace period where deadlocks or wait requests happen? any links would great :) Many thanks S... 30 Jun 2010 05:26
running a job I'm trying to figure out what some fired consultants did for us and of course I can't ask them. They have a process I run by executing the following sql command: exec msdb.dbo.sp_start_job @job_name = 'B0C5788B-3F0C-4A94-81BC-12715D9891F6' Where is this job 'B0C5788B-3F0C-4A94-81BC-12715D9891F6'? I'm trying... 29 Jun 2010 10:46
Serial Motor How do you control a motor via serial port? What language should I use? ... 29 Jun 2010 05:18
Locking at delete statement(SQL2008) Hi, if I have delete statement on my table over ident column, is it possible that it blocks insert statements from other users? DELETE from my table WHERE idIdenty<@idIdenty New inserts would have idIdenty larger than the ones, that are currentyl deleting, so, the delete statement should't block other users... 29 Jun 2010 04:11
Policies Hello, We are testing the use of Policy management framework and thus my manager has entrusted me to collect some sample policy ideas which can be implemented across the SQLServer enterprise. This is apart from the default policies that MS has shipped. The idea is that each team memver develops a policy and ... 28 Jun 2010 18:24
Monitoring UPDATE , SQL Server 2005 Forgot to say we are using SQL Server 2005 Standard "Bassam" <egbas(a)yahoo.com> wrote in message news:ukbvh1eFLHA.5472(a)TK2MSFTNGP04.phx.gbl... Hello, I'm suspecting that a user in the network is using management studio or other tool to login with his name behind the scenes and updating a certain ... 27 Jun 2010 08:29
Monitoring UPDATE Hello, I'm suspecting that a user in the network is using management studio or other tool to login with his name behind the scenes and updating a certain table , how can I monitor that event ? to know user login/machine/time/statement used ? PS. I can't use Profiler , is SQL Server itself have a log for th... 27 Jun 2010 10:39
parse name and address I have a SHIPTO field that includes name and address separated with carriage returns. Using CHARINDEX I tested for Char(13) and Char(10) and they are intact. How do I parse that field into separate fields when I don't know how many instances of CHAR(13)CHAR(10) there are? I will have FullName, Add1, Add2, and m... 26 Jun 2010 19:36
Open a Windows Form from SSRS I am trying to open a Windows form from an SSRS report - I tried the Navigation, but no luck with it opening. Does anyone know how can this be done ? ... 25 Jun 2010 18:41 |