Search results for query: *

Well I figured out the issue at least in my case - the destination cannot be a unc - only works when it is entered as N:\Prod_db (for example) in the copy tab of the configuration. It does not need to be a share (and it did not work when it was a unc and the folder was a share) I thought this...

As an added note, I even made the sql server service account (same account sas the agent) a local admin and still no luck...

Hi - I ran into an odd issue when configuring log shipping. The transaction log backups work but, the copy job fails with the following error: 2010-08-16 11:19:00.97 Copying log backup file to temporary work file. Source: '\\xxxx\PROD_db\PROD_db_20100816165505.trn', Destination...

I am guessing it's an issue with one of the application's config files because as I said I have successful logins coming from the same server that is generating the failed login attempts. The application only uses one account (which makes the troubleshooting a little challenging). The password...

I am getting a login failure message: Login failed for user 'user'. [CLIENT: xxx.xxx.xxx.xx] Error: 18456, Severity: 14, State: 16 I know this normally means the account does not have permission to the default database however the account is successfully logged in and does have public on...

I am getting a login failure message: Login failed for user 'user'. [CLIENT: xxx.xxx.xxx.xx] Error: 18456, Severity: 14, State: 16 I know this normally means the account does not have permission to the default database however the account is successfully logged in and does have public on...

Quick question.... I have a report with many subreports that prompts for windows credentials and the server and instance against which it is to be run which works great with windows authentication. I need to use SQL authentication on some servers (no trust between domains). The problem I have...

Hi, I've run into an issue when I create a local group on my laptop (32 bit o/s) that is running SSMS 2008 Microsoft SQL Server Management Studio 10.0.2531.0 and export it. I can export the group however when I try to import the group on another server or laptop I receive an error message...

Figured it out... I was going about it the wrong way. I tweaked the query to order by using the cast above and then added a field to my dataset (expression based) that does the conversion and modified report groupings etc to use the new field.

I am trying to create a space usage report and the challenge I have is the date is stored as a varchar in the column in the table. I can convert this easily in sql (so that when you group and order the data it does so correctly when there is data from the prior year) however I cannot get the...

Yeah I was just trying to keep it simple and clean while still having all the code in the job. You're right though - probably time to start learning PowerShell. I was hoping I was just missing something.

I can do that and it works but, I am trying to understand why it doesn't work as one step with 2 lines of code in teh sql job as I may need to know for a future sql job (it works fine in the bat file)

This is the mssqlsystemresource db that came along with sql 2005. You cannot back it up using the normal database backup commands. Per Microsoft (and yes I've tested it) you copy the .mdf and .ldf files while sql is running to a new location. I have done that and am using the move command to...

Is this a cluster?

As far as I know licensing is by Edition not by 32 bit or 64 bit. There is a link to the EULA in the link below: http://www.microsoft.com/sqlserver/2005/en/us/licensing.aspx

I have a sql job that has 2 lines of code to rename 2 separate files. The problem I am having is the job only runs the first line of code and then reports success. If I put the code in a bat file it runs fine. move /Y S:\"Microsoft SQL...

Thanks Robert - I went with modifying the data captured as that seemed to simplify the issue. Once I removed the group by it worked well - with the group by it returns an error: ach GROUP BY expression must contain at least one column that is not an outer reference. Msg 164, Level 15, State 1...

Is there a way to take the data from sys.extended_properties which has 2 key columns looks like this for each db: name value MS_Application DBA Tools MS_Description Database used by dba and pull that information into a table in with the following format...

I have 2 tables - one contains application information that has been pulled in from the extended properties and looks like: Application information Table: DBName Application Description test1 MS_Application Test Application test1 MS_Description Used for...

I have a quick question... we need to pull data from 2 databases and combine it in a report. Is it better to create a view that is select * from dbname.dbo.table in the reporting instance or just query the table directly using .... from dbname.dbo.table in the reporting instance?