Viewing 15 posts - 31 through 45 (of 109 total)
quote:
I have been watching the deadlocks using Profiler and also DBCC TRACEON(1204,3605,-1) and have found that any statement that changes the status...
September 15, 2003 at 4:47 am
You are right Frank.
Actually Scheduler is a great out of the box tool provided with windows.
Pay Respect to People on your way up. For you will meet the same People...
September 15, 2003 at 3:47 am
I am not aware what sort of reporting you are planning at.
I had to work on a reporting app a few months back, What I did was I developed...
September 15, 2003 at 3:35 am
You can write your code in Visual basic and schedule it using NT-Scheduler.
Pay Respect to People on your way up. For you will meet the same People on your way...
September 15, 2003 at 3:12 am
Are you trying to connect through a machine other than the one on which sql server is installed. What Login Name are you using, since you have mentioned that you...
September 3, 2003 at 5:04 am
What is the error that you are getting.
If you are trying to connect using sa account under the security option set the authentication mode to both sql server and windows.
Pay...
September 3, 2003 at 1:23 am
Fully Agree to what steven and frank says.
Pay Respect to People on your way up. For you will meet the same People on your way down.
September 3, 2003 at 1:18 am
They are under the master database.
Pay Respect to People on your way up. For you will meet the same People on your way down.
September 2, 2003 at 11:17 pm
Try using the command object instead of the connection object, it is more Intuitive for stored procedures that return values.
Pay Respect to People on your way up. For you will...
September 2, 2003 at 10:41 pm
Try using the command object instead of the connection object, it is more Intuitive for operations stored procedures that return values.
Pay Respect to People on your way up. For you...
September 2, 2003 at 10:41 pm
Try this example
create procedure p @p1 varchar(100)
as
exec('select * from ' + @p1 + '.dbo.sysobjects')
Pay Respect to People on your way up. For you will meet the same People on...
August 31, 2003 at 11:39 pm
This are my details
7 years of IT experience that consists of web application development using ASP, IIS, COM+, SQL Server, VBScript and JavaScript and n-tier business applications development using COM,...
August 31, 2003 at 10:24 pm
One way is to set the isolation level to the highest i.e. seriallizable.However this may result in command time out,so you may need to increase the command time out of...
August 31, 2003 at 10:19 pm
How About this
declare @j-2 int
declare @i int
set @j-2=1
declare a cursor for
select [column] from
order by [column]
open a
fetch next from a into @i
while @@fetch_status=0
begin...
August 29, 2003 at 4:43 am
Information about foreign keys is stored in sysreferences table.
The colums fkeyid and rkeyid are the objectid's of the referencing table and the referenced table respectively.
Pay Respect to People on your...
August 29, 2003 at 2:55 am
Viewing 15 posts - 31 through 45 (of 109 total)