Forum Replies Created
Viewing 15 posts - 9,676 through 9,690 (of 9,715 total)
-
RE: Configuration File Drama
We've tried everything we can think of to deploy properly. Our problem is that we don't have separate servers for Dev/Test/QC. We've got the same server for all three with...
-
RE: Configuration File Drama
Lee,
Thanks for the response. I posted a reply on your thread as to what we finally figured out the problem was. We don't have a solid resolution yet that applies...
-
RE: Changing connections at run time
Lee,
You replied to my post and I'm going to now reply to yours. Several days after I originally posted, I found the problem with our situation & config files.
When you...
-
RE: Data Output tab on Subreport properties
Thank you for the information and the link. It is greatly appreciated!
-
RE: Procedure parameters return exact values but does not generate dataset based on the provided variable.
You need a case statement in the WHERE clause of your procedure.
My situation is doing a Data Dictionary where I give the user an option to choose a...
-
RE: Very large and slow differential backup
There is another option. Make some of your filegroups READ ONLY, then backup only the filegroups that are READ/WRITE. @=) (see Partial Backups in BOL)
Or do put your large table on its...
-
RE: High CPU usage after a backup
I'd recommend running SQL Server Profiler to see if there are any other jobs running after the backup which are still using those resources. If not, run Windows Performance Monitor...
-
RE: "Execute As" and xp_cmdshell
Also, as an FYI, while xp_cmdshell by itself is considered a security issue, it is disabled by default in SQL Server 2005. So if you (and no one else) has...
-
RE: Full Text query times out on execution
Check BOL for the following keywords "Full-Text Search [SQL Server], performance". There's a ton of information on the page, so I'm not going to quote it, but I think your...
-
RE: Very large and slow differential backup
To answer the second question first, I'm betting the USB connector is the issue for the slowness of the backup. USB isn't quite up to speed with other disk drive...
-
RE: Multiple collation and tempdb
Individual database collations can be "changed" when they are created, but the System DBs get their settings from the server itself. So, if you want to change TempDB, you'll have...
-
RE: Importing Identity field values to SqlServer 2005
Simpler way to do this? No. SSIS is capable of doing so much more than DTS that the this task has become a bit more complicated rather than being streamlined.
However,...
-
RE: Importing Identity field values to SqlServer 2005
Glad I could help. @=) And my apologies for the initial mis-direction.
-
RE: Importing Identity field values to SqlServer 2005
You are correct. I mis-spoke.
Try this: Pull over a Data Flow Task. Double-click it or Click the Data Flow Tab and arrow down to the Data Flow Task if it's...
-
RE: Importing Identity field values to SqlServer 2005
Are you just doing a data transfer? No triggers, etc. If so, maybe what you need to do is resort to an Execute SQL Task and stick a SELECT statement...
Viewing 15 posts - 9,676 through 9,690 (of 9,715 total)