Thanks for the input guys!

Updated yet again...same old links but new code.

sp_GetDDLa_Latest.txt (Returns Table)

sp_GetDDL_Latest.txt (Returns varchar(max) )

[/quote]

this version is greatly enhanced;

--scripts any object(table,proc, function,trigger)

--has the nvarchar fix so they...

openrowset or openquery, which is a kind of temporary linked server...

is the question how to do that, or is this a question more along the lines of connectivitiy options?

SELECT *...

Rob-350472 (2/28/2012)

---

That's a very comprehensive calendar table! Thanks for the linkage. The calendar table isn't so much the issue, how I use it is the issue!... I could knock up...

Import rights = which database?

you have to define that a lot better;

if this is for one existing database, you need to add the login as a user to that...

for your specific quesiton, i'd add one more calculated column to make life easy:

--IsWorkDay?

ALTER TABLE TallyCalendar

ADD IsWorkDay AS CASE WHEN IsWorkHoliday = 1 OR DayOfWeek IN('Saturday','Sunday') THEN 0...

yeah a Calendar table is definitely the way to go.

I've posted one here that is one of the better versions out there...it features all the funcitons to generate US Holidays,...

mail.baberkhan (2/28/2012)

---

BULKADMIN

BULK INSERT administrators. Can load data into tables using BULK INSERT statement.

Database administrators responsible only for loading data through BULK INSERT. Data import specialists.

So With Bulk Admin rights...

wierd; how is the data being inserted into the out_dialler_calllist...

if you declare a varchar/char/nvarchar with out a size, it is a single character.

only in a cast/convert is it 30 chars without the size declaration.

declare @var varchar

declare @var2 varchar(50)

besides that,...

the unexpected results is just what Alexander is experiencing; but this is technically a known behavior.

his expectation...

ok , so if it's async, i'm assuming the data values have been inserted or updated to some table, and then the service broker is getting called....in a trigger,...

andrew do any of these DMV's help you get the iinfo you are looking for?

select * from sys.sql_expression_dependencies --(2008 +)

select object_name(id) as MyObject,object_name(depid) as ReferencedObject,* from sys.sysdepends ...

kramaswamy (2/27/2012)

---

Hi all,

Got a situation which I'll simplify into the following question. Let's say I have this block of code:

CREATE TABLE TestTable (ID INT, Val VARCHAR(20))

BEGIN TRANSACTION

INSERT INTO TestTable (ID,...

If you had massive amounts of data like L' Eomot Inversé 's example, I'd think that using .NET or ADO to bulk insert would be the solution;

accumulate the data locally...

backup and restore are the best solution i think.

it will copy all objects perfectly that exist inside the database...that' distinctino is important, because you asked about:

will to copy all db...