In the production environment, No one gets Db_owner rights. No one. Now in a development environment, I tend to be more lax as I don't want to be...

This could take a while depending on what the process was doing. I've seen them take hours, so be patient, or you will end up with a suspect database

Also could be a resource problem. First thing I'd check is if you yourself can connect. If you can, then it's time to walk the road of network...

Ansi joins are the way to go, they are much easier to understand for all databases.

Agree with others here. Of course, this is a good way to ensure job security as someone will have to clean this mess in the future

Remember,

Setting a good size now will prevent file fragmentation. Also, remember to spread your file groups across different physical drives if possible. Some use autogrow, I tend not...

Terry (I learned from Steve's mistake)

That is a good list. The only thing I would add is any known growth/data bases in the pipeline. A DBA should always...

Gavin

Please include the DDL for your table, that helps a person determine how to self join the table and get the results you need.

Thanks

Lisset

What is happening is that you need to remap the source to target mappings, once that is accomplished the error should disappear.

Calm down...it's the nature of the beast. Some programmers take writing SQL Code for granted, and as long as they get the data eventually they are happy. Remember,...

Place the expression in the ExcelFilePath property. Connection strings are for OLEDB type of connections, whereas the excel file path is the physical path of where the file actually...

Alex

You can set the column delimiter in the SQL Server Import/Export wizard, the first screen is choosing the data source (SQL Server), second is choosing a destination which in this...

Nicole

The above mentioned way is the preferred way to do this. To create a Job in sql server, right click on the jobs folder under the sql server agent...

ONe question, are you backing up to a network drive. If so, bad choice as any small blip on the network will cause your backup to fail. Try...

Lynn

Thanks for the update, also change the last block from @DateB to @DateC. I either had fat fingers or brain freeze. It's only 11 so brain freeze should...