Check the logical filenames by right clicking on the Database in SSMS and select properties. Then Click on the Files Tab. You want the logical file...

You have the syntax correct but you want to use the logica name of the datafile and logfile.

The syntax is the same for the Log File as the Data File.

Check...

You can easily create a maintenance plan it will create a text file so that you know what Indexes have been rebuilt and which one was being reindexed when...

DBCC SHRINKFILE is preferable, because you have more control over it.

You should only perform a shrink operation if you have a lot of space that you need to free...

Post removed.

You can only join tables on common elements. GroupName (Generic Name) to Group Name or GroupCode to Group Code.

The database should be storing the code in the child table so...

Why do you want to do this?

Jeff Moden (8/18/2011)

dji (8/18/2011)

If I understand correctly, though, most folks I know say that SSIS won't import "text qualified" files (files with double quotes in them if a delimiter, such...

If you look at the MERGE example and...

Processing a record one by one is going to be slow.

The merge statement is your best option.

The following is an example.

http://www.mssqltips.com/tip.asp?tip=1704

You can't do this just using T-SQL.

You could call a SP and return a URL from within .NET.

There is a language property that can be set.

http://plataan.typepad.com/microsoftdynamics/2009/03/reporting-services-tip-about-using-the-users-regional-settings.html

You were told that you have permissions but I would verify.

Go to someone that you feel comfortable and verify what roles you are a member of, etc.

Have you checked the SQL Server error log?

http://msdn.microsoft.com/en-us/library/ms366351(v=sql.100).aspx

You may also try this troubleshooting tool.

http://blogs.msdn.com/sqlsecurity/archive/2010/03/29/sql-server-authentication-troubleshooter.aspx

I would explicitly CAST as VARCHAR.