I remember the feeling. Even if it was a LONG time ago. I actually feel that way right now with C# to some...

I'm sorry but this is WAY more complicated than you will want to do. IMHO. Joe was correct in what he said. You really need to think about the model....

#1 SELECT SERVERPROPERTY('LicenseType'), SERVERPROPERTY('NumLicenses') should give you the License and Number of seats. SERVERPROPERTY also has other items of interest. I suggest you look it up.

#2 Use the SP:StmtCompleted in...

If you have SQL2K and have it running under a local user account rather than as Local System you should be able to step into your stored procedure. To do...

In your code above the @PrimaryKeyValue variable will only accept the value from the SP call if you explicitly tell it that the parameter is an output parameter.

CREATE PROCEDURE usp_FacilityAddress_Insert

  ...

You might also think about using a UDF for this. That way you don't have to create a global table and anytime the parameters are the same you should get...

I use COLLATE all the time as we use the Latin1_General_Bin collation as the default collation on our database. So if I need to compare case insensitive data I need...

If you change this to use sp_ExecuteSQL you should no longer have a problem.

declare @str1 varchar(8000),@str2 varchar(8000)

exec sp_executesql @str1+@str2

If you look up sp_executesql in SQL BOL you will notice...

Try

declare @IDENT INT, @SQL varchar(1000), @DBNAME VARCHAR(200)

select @IDENT=min(dbid) from sysdatabases WHERE [dbid] > 0 AND name NOT IN ('PUBS',

'NORTHWIND', 'TEMPDB', 'EStar', 'master', 'MAW_FE', 'MAWData', 'MAWOfficeSupply',

'model', 'msdb', 'tempdb', '_MAWDataDev',...

Sorry, I had written up a reply last night but I guess it didn't go through. Basically what I would do in this situation is to create a UDF that...

I'm pretty sure you can't do a self reference in the "Formula" for a field. This is due to the fact that "Formula" makes the field a computed column and...

Sylvain,

That is the reason I stated that it ultimately depended on their business needs. It may be easiest to simply restore a database on the remote machine. Without knowing their...

Why can't you do the concatenation during the initial insert?

INSERT INTO test_show(uID, content)

SELECT tm.uID, tm.content + tc.text

FROM test_match tm

    JOIN test_cat tc ON tc.uID = tm.uID

While the software from Red-Gate will work I think an easier way would be to simply use a backup/restore scenario. Another way to do this would be to use Replication with...

While the script above will do precisely what you asked it would be much better to create a database role and grant the permissions to that. Simply create the role...