Is there any way to re-seed an IDENTITY(1,1) column back to recommence at 1
without DROPPING the table but after a DELETE FROM table? SQL Server 2005.
Thanks.

I get 'incorrect syntax near 'P' - not very helpful.
Also, how would I cater for the left joins returning null names, (i.e. where
a parent has no children or employer)?
Also not sure the last left and inner join is correct. the ParentEmployer

I develop on my laptop with a local copy of sql2k5.  After installing sp1
for vista biz, I am no longer able to connect my apps to the local sql
server.  The apps do work just fine with the production server.
Where to begin troubleshooting?

Can you put a description on a stored procedures parameters that you can get
back in a query like you do for a field in a table?
Thanks,
Tom

I have a VB.Net app (using ADO.Net) which calls a stored procedure on a
local sql server instance, which, in turn, calls another SP via a linked
server which points to yet another local sql server instance.  I am able to
debug everything except the last SP residing on the 2nd ...

Does anyone know if it is possible, and if so how, to use a dynamically built SQL statement as the source for a cursor in T-SQL?
For example, I'd like to do something functionally like the following:
DECLARE @TABLENAME varchar(255)
DECLARE @ID varchar(255)

I have a  project and I wonder if I could get some recommendations
from this group.
SQL 2005 Server database
The table we are interested in contains about 70 fields of data and we

How should avoid null columns in a table.
Ex
I have Table called Test
Emp_code          Name             DOB

I want to store the results of restore filelistonly in a temp table
by using the following command.
INSERT INTO #RestoreFileListOnly
exec( 'restore filelistonly from disk = ''C:\Backups

I want to run sp_stop_job to stop a SQL Server job but I get an error
message that its not running.
How can i check the status of the job before applying/not applying
sp_stop_job to stop it?

i want to insert Default value in a table.
suppose
create table Test(id int, name varchar(20), salary int default 0)
now when i run following query

I'm getting a syntax error, it says near ',' - not very helpful. How do I
specify the data for (a) a bit column (b) a datetime column
Here is my insert (as mangled by query builder):
INSERT INTO dbo.Parent (FirstName, MiddleInitial, LastName, GroupId, SSN,

Doh..
SQL 2005.
what if the only instance on the DB server was MyServer/BadName .. and
attempting to connect to MyServer (default) was of course not

I need to figure out a way to schedule a .bak file transfer from a remote
computer to our server. I know that SQL server 2005 express edition does not
have a job scheduler of any sort so I will have to use a third party tool
for a scheduled SQL backup. Is there any way to ...

All,
Thanks for any help on this…
[TabeA](
[originzip] [char](5),