Hi,

If I have understood the question correctly then you could use a PIVOT function to acheive this.

http://msdn.microsoft.com/en-us/library/ms177410.aspx

Hope this helps.

Hi,

I have already provided you with a link for this in one of your other posts

(http://www.sqlservercentral.com/Forums/Topic777335-146-1.aspx)

Can you please stop making multiple posts.

Hi,

Check out;

http://www.sqlservercentral.com/articles/Administration/fragmentation101/1346/

There may be a better way to do this but I would do something like this;

DECLARE @IdEmpresa INT,

@IdOficina INT

SELECT @IdEmpresa = code to set the value,

...

Hi Luis,

Can I ask how these values are set? Are they outputs of the previous procedure calls within the job.

Am I right in assuming your job is simply executing...

Hi,

I think this may be able to help you out;

SELECT SysT.Name AS TableName,

SC.Name AS ColumnName

FROM Sys.Tables SysT

INNER JOIN Sys.SysIndexKeys SysIK ON SysT.object_id = SysIK.id

INNER JOIN sys.syscolumns SC ON SysIK.colid =...

or in your case;

sp_msforeachdb @command1 = 'SELECT [ABC]

,[123]

FROM [dbo].[tabledata]

Where FieldName = ''QWERTY'''

Hi,

You could use the undocumented function sp_msforeachdb.

Simple as;

sp_msforeachdb @command1 = 'SELECT ''123,?'''

The ? is the variable, in this case the database name.

Hope this helps.

Thanks for the additional info.

I assume the agent has permissions to write where you are trying to backup to.

Have you tried logging in (assuming you have permissions) and manually running...

Hi,

Is there any more information, other than the code? Try having a look in the error log and event viewer.

Is this error occuring when you run a backup or...

what happens when you remove the PRINT statement again, does it still run in 130 seconds.

It sounds to me as if the procedure is cached.

I had the same issue, this may sound silly, but when you copy the data from the window, wait 5-10 seconds and then paste it into your other application.

Obviously watch...

Hi,

I'm currently doing a similare excerise to reduce the fullscans/sec on some legacy objects.

One thing that helped me was to profile the 'Scan Started' event and set a filter where...

Also found this, it may be of some use.

http://www.sqlbackuprestore.com/backuprestorehistorytables.htm

Hi,

Have a look in;

SELECT * FROM msdb.dbo.backupmediafamily

It contains a number of records for each db, so you will need to get it to only pick up the latest one, but...