You can encrypt your stored procedure code by using the "WITH ENCRYPTION" option.  Look up BOL for more information.  Once the stored procs. are created with this option, the text...

It was a typo on my part...I meant to write do NOT get re-used automatically unless you take care of re-sequencing by using a script...thanks for correcting it.

--Script:

SET NOCOUNT ON

--Declare the table variable

DECLARE @LogTimes TABLE(

EmployeeId varchar(10) NULL,

Project VarCHAR(10) NULL ,

LogIn DATETIME NULL,

LogOut DATETIME NULL,

Time int NULL)

--Insert the records

INSERT @LogTimes SELECT '123', 'A', CONVERT(VARCHAR(10),...

1) You can check what the current identity value is by doing:

select ident_current('table_name')

The next value will be the higher increment i.e. the next value.

The missing values (aka holes) in...

CREATE TABLE XXTSTATS

(

 xts_dw_count  INT,

 xts_table VARCHAR(10)

)

GO

INSERT INTO XXTSTATS VALUES (0, 'MY_TABLE')

GO

CREATE TABLE MY_TABLE (COL1 INT)

INSERT INTO MY_TABLE VALUES (1)

INSERT INTO MY_TABLE VALUES (2)

INSERT INTO MY_TABLE VALUES (3)

GO

DECLARE @table VARCHAR(10), @CMD NVARCHAR(100)

SET...

There isn't much of a difference. By following what your DBA is saying, you will avoid one SQL statement that checks for the existence of a record (but that...

Anuj:

Folks can help you with specific questions. As a starting point, look into SQL Server Books Online (BOL) or at this site for more information and if you get...

1GB of RAM is very less if you have your application, IIS and SS2k running on the same machine. If you are using SQL Server Standard Edition, then you...

There is actually a bit more to it depending upon the ANSI_PADDING settings...see this discussion thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=226423#bm226578

Did you check the error due to which it failed ? Fix that issue that caused the job to fail and re-run the job (you can right click and...

Please don't cross-post...your question was answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=246133

I am assuming that it is a inserting a bunch of records in one shot otherwise, it is fairly simple to catch this with profiler i.e. you are doing "insert...

You can use a temporary table for that.

select id, identity(int, 1, 1) as row_num

into #temp

from existing_table

Once that is done, you can update the existing_table's new column with the row_num...

Is the update on table2 on ServerB database based on data from table1 in ServerA ? If so, you can define a linked server on ServerB that points to...

Defaults don't work that way. If an explicit NULL value is provided, that NULL value is used for doing the insert instead of the default value for that column....