Does this return the value of that parameter? Remember though just cause it has a parameter called dbname it doesn't mean thats the only db it accesses.

SELECT object_name, parameter_name, design_default_value,...

durga.palepu (6/23/2016)

---

SQL Agent Jobs information is stored in msdb databases.

But In latest version of SQL Server say SQL 2012 on wards, the SQL Agent Jobs info is directly saved into...

What size is the file? Compare it to the max file size when you run this command

EXEC msdb.dbo.sysmail_help_configure_sp ;

Does the user the SQL Services is running under have...

If you have 3 datasets embedded in your report and they each return 100 rows then the row count in the execution log should display 300. If the datasets are...

You can't have SSRS default to an exchange alias. It uses the alias against the AD account. Changing that setting to false opens up the to box to allow users...

SELECT name FROM msdb..sysmail_profile

If you execute t-sql in a try catch block then you should notice no difference between this and executing the same T-sql outside of a try catch block.

The performance overhead...

Here is one way you could do it.

SELECT

j1.item_id

FROM #jec_item_sup j1

EXCEPT

SELECT j.item_id

FROM #jec_item_sup j

WHERE ...

Tools > Options > Text Editor and untick highlight current line.

Are you sure you have deployed the sub reports?

To convert back do this

SELECT CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), '0x53514C205365727665722043656E7472616C', 1))

The original query above can be inserted into a table no problem. I don't see anything good about that function. it...

In science they say - the shorter the title the deeper the book.

Your "simple question" is not really that simple.

Someone who knew that "simple answer on a simple question" put...

You don't need to use that function. You can do it like this:

Select CONVERT(VARCHAR(MAX),CONVERT(VARBINARY(MAX),CAST(

'['+Table_Catalog+']'

+'['+Table_Schema+']'

+'['+Table_Name+']'

+'['+Column_Name+']'

+'['+CAST(ORDINAL_POSITION as varchar ) +']'

+'['+ISNULL(COLUMN_DEFAULT,'')+']'

+'['+ISNULL(IS_NULLABLE,'')+']'

+'['+ISNULL(DATA_TYPE,'')+']'

+'['+CAST( ISNULL(CHARACTER_MAXIMUM_LENGTH,0) as VARCHAR ) +']'

+'['+CAST( ISNULL(CHARACTER_OCTET_LENGTH,0) as VARCHAR ) +']'

+'['+CAST( ISNULL(NUMERIC_PRECISION,0) as...

No the next transaction log backup won't be 332gb - it will be a lot smaller. Take another log backup and then try shrinking the log file again. If you...

Have you set up the tnsnames.ora file on the SQL server and have you verified the information in the tnsnames is correct?

Are you sure the tnsnames is in the correct...