Hi Steve,

Are you looking at a query that would list out all users along with their permissions on objects?

You could create a DNS entry (myReports.com) for myservername.com. For the URL redirection part (without /reports), it has to be done at the IIS level. But since SSRS 2008 and...

Not really 🙂 its just that I am not aware of other options 🙂

I tried backup and restore option, that is also erroring out. Is there any other direct way of upgrading from 2000 to 2012 other than having an intermediate 2008/2008 R2...

Can SQL 2012 client tools be installed in windows xp or client tools also require win 7 and higher editions?

Thanks

Maintenance plans are stored as SSIS packages. They can be exported and saved to file system/SQL Server.

Follow the below steps:

1. Connect to Integration Services of the SQL Server that has...

You can try one of these options:

1. Use Import/Export wizard

2. BCP out from source and then BCP IN in the destination

3. Use OpenDataSource

Try this:

SELECT LEFT(SHIFTLABEL+ replicate('0',6),6)

Please try this:

C:\Program Files\Microsoft SQL Server\100\DTS\Binn>DTEXEC.EXE /F "C:\DbfExport.dtsx"

Reference:

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

Check these links:

http://www.sqlservercentral.com/Forums/Topic595224-357-1.aspx

http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/31995/

Have 2 traces, one filtered on database name and the other one on textdata column.

1. DatabaseName Like DB_1

2. TextData Like %DB_1%

If the old destination table and new destination table are the same and only the connection is different, then you can just change the connection. After the connection is changed,...

Hi

Please try this:

1)SSMS -> Server objects -> Linked Servers -> 'New Linked Server'

2)In the pop-up window “New Linked Server”, select the General tab

3)Specify an alias name in "Linked server"...

Replace the CREATE LOGIN statement with the below statement

SET @cmd = 'CREATE LOGIN [' + @input_login +'] WITH PASSWORD = ' + QUOTENAME(@input_pass,'''')

1. Install SQL Server 2000 DTS Designer Components

2. Install SQL Server 2005 Backward Compatibility Components

3. Copy these files

(a) On a 64-bit computer, substitute %ProgramFiles(x86)% for %ProgramFiles%...