Viewing 15 posts - 2,566 through 2,580 (of 3,232 total)
Is this a static query or was this generated by an application? To answer your original question, yes, all you should need to do is change your dates. Keep in mind...
October 27, 2006 at 11:23 am
Well, its hard to tell you if there is a way to change this in the query if we havn't seen the query. Can you post your query and an...
October 27, 2006 at 10:28 am
This is probably not the answer that you want, but it sounds like you need more disk space. If users are allowed to create and use temporary tables in a...
October 27, 2006 at 10:22 am
Unless you are a domain administrator in both domains, you can't do what you want. The Domain Admin. must set up a trust relationship between both domains. Are theses scheduled...
October 27, 2006 at 9:40 am
John,
Try/Catch blocks in SQL Server 2005 are used for error trapping. I have not seen any information relating them to blocking. Can you post the link...
October 27, 2006 at 8:44 am
Well, where did you copy the .bak to? The Windows account running your SQL Server service must have read access to the folder where you've placed the .bak file.
October 27, 2006 at 8:01 am
I'm confused now, your latest post says that your SQL Server is using half of the CPU. Is this correct? If this is the case, adjusting your Memory settings isn't...
October 27, 2006 at 7:56 am
To use fixed memory in SQL Server 2005, you need to set the minimum and maximum memory setting to be equal to each other. It is recommended to allow SQL...
October 26, 2006 at 3:10 pm
Well Will, I think I'm lost anyway. Can you post your DDL for both tables as well as a bit of sample data for each table and your expected result. ...
October 26, 2006 at 3:04 pm
When you say 'files', I assume that you are only referring to the backup file correct? There is no need to 'attach' any files. Can you clarify your last statement...
October 26, 2006 at 3:01 pm
No, SQL Server does not have a split function. That is why I told you to seach this site for it. I could give you links to it, but there...
October 26, 2006 at 2:50 pm
Look up RESTORE DATABASE in BOL and refer to the WITH MOVE clause. This will allow you to use your backup file to create a new database. Either that or...
October 26, 2006 at 1:28 pm
Well, it looks like you've tripple posted. Let's continue this in your Administration post:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=318400
October 26, 2006 at 11:27 am
The entire DTS module is also being re-written in SQL Server 2005 into SSIS. Bulk Insert is part of DTS and will be included in the re-write. Both Bulk Insert...
October 26, 2006 at 11:18 am
I would use a split function to split the 'Quarter' values into a table variable and then rank them on the value (without the 'Q') converted to int. Search this...
October 26, 2006 at 10:36 am
Viewing 15 posts - 2,566 through 2,580 (of 3,232 total)