I want to set an identity column for a table that contains destinators for
SMS messages. This table will grow really quick.
I'm worried about stablishing an id column as Identity colum (auton
increments id) and type: Bigint (8). What happens when the Id column reaches

I use a VPN link to connect to a SQL Server at the office. There must be a
way to connect without the VPN, since I can connect this way to a SQL Server
at our ISP. How do I enable this?
Best regards

Here is my procedure
ALTER PROCEDURE dbo.mAssign
@qState VARCHAR(40),
@qTeam VARCHAR(40),

I want to create the procedure in my dynamic database like that but it's not
working... can any one add their idea regarding this... Thanks
DECLARE @SQLSTATEMENT VARCHAR(200)
SET @SQLSTATEMENT = 'CREATE PROCEDURE '+@DBName+'.dbo.Portal_AddEvent

I can't remember the default password that accompanies the sa login id.  Can
anyone help me out with this?

I'm a normal resident of the vbscript/wsh/server scripting forums, as I'm
more of a scripter, and don't know word one about SQL...so here I am  - :)
I'm attempting to query a MS WSUS database stored on our SQL server (SQL
2000) - one of the two fields I am querying is reporting ...

I'm creating a web application that write to a SQL Server 2000 database.
There are fields for Name, Address, City, St, Zip.  There are also 4 fields
that the user will use to type in descriptions.   My table looks like this.
ID              Int

Is there a preference in sql server 2005 as to how fields/objects are named
such as Client_Address, Client Address, Client-Address or ClientAddress?
Also what are the reserved words that should be avoided in field names?
Thanks

I understand the dbo.dtproperties tables is a system table, but it appears
under "User Tables" in my Query Analyzer.
Is this normal , or does it signify a problem ? I have never seen it there
before.

I've tried to get job status wheter its success or no so I can put my
coding in each condition.

how to use it..

The cost of query with usage of functions is as same as that of without
functions
In the below code, the query cost of insert is 0.02% and two select
statements costs same 0.04%

Should every table have a primary key?  What are the criteria for adding one
besides distinction?  Do integers make better keys?  If there is no logical
choice for a key on the table, should one create an Identity field in the
table and assign it as primary key?  Also, should the ...

Dear SQL Guru,
I just found out this morning that my SQL Server box had been added 1
more instance. Below is the example:
PPAPP0075\FINANCE    (Old instance)

 Before I go into specifics, this is my problem. I've have a table
that gets updated with large amounts of data on a monthly basis.
Sometimes (rarely) identical rows of data are on one months import that
already exist from the previous month. I can identify these rows from a

The event log is showing a ton of failed sa logins. The server is connected
to the net. I am assuming this is a dictionary attack to get the sa
password. I am trying to find out if this is an inside attempt or from the
outside. While the profiler will tell me which program or script ...