What I would do is forget import/export. You should make access a linked server and then you can move huge bulks of data very rapidly.

e.g. Note: You...

I used the same function that Jsheldon recommended. You will be able to adjust either one to suit you needs.

This is a built-in function to apply an action to every database. I have modified it to exclude system databaeses.

declare @username as varchar(100)

declare @runcommand as varchar(100)

SET @username = 'TEST_USER'

EXEC master..sp_MSForeachdb...

NP thanks for the feedback. 😉

This looks like a perfect example of using the str function, which converts a number to a string value.

declare @i float

set @i = 8810657712.0

Select str(@i)

On the test server right-click the database --> tasks generate scripts --> select stored procs.

You will have select the option to create delete statements, so the previous version gets deleted.

Once...

The only other thing it could be is you do not have rights to see the procedure. Confirm that you have the appropriate credentials.

What if the stored procedure is...

Also, just an FYI you should not named stored procedures sp_Name because this is the Microsoft standard. SQL Server will first look in the system stored procedure list and...

hmm. this is interesting.

try to do a search on sys.procedures.

select *

from sys.procedures

where name like '%dbo.sp_abc%'

Does anyone have any words of advice/code snippets etc etc on how to dynaically create insert statements e.g with a list of tables names that I feed into information_schema.columns can...

Check for a synonym for the stored procedure

Does this mean you are a member of builtin admins? You should be able to login in if you are.

Additionally, I have...

Was the job step executed using the TSQL job action? If so check which database the stored proc is using in the dropdown and then check the procedure to...

another link

http://technet.microsoft.com/en-us/library/ms189085.aspx

When you shrink a log file, you are removing all inactive virtual logs that do not hold a piece of the logical log. All virtual logs are removed from...