Viewing 15 posts - 871 through 885 (of 2,612 total)
Great to have you onboard.
It may help to post this in a way that makes it really easy to help you.
http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D
July 30, 2008 at 10:42 am
It depends on the problem you are trying to solve.
If this is a code-reuse issue you are trying to deal with, you could encapsulate the code for populating the temp...
July 30, 2008 at 10:39 am
That's exactly what I do also, but I always try the uninstall anyway - just to see what happens.
July 30, 2008 at 10:33 am
I used a beta 2, two different CTP builds, and RC0 and had trouble with the uninstalls of all of them. It may take some work to get your...
July 30, 2008 at 9:56 am
As far as the latest changes you made, if you stop the SQL Service (if it actually starts), you should be able to copy the mdf and ldf files to...
July 30, 2008 at 9:32 am
You can create synonyms for procedures and functions also, but I think the easiest solution for you would be to restore a backup of your user and registration databases from...
July 30, 2008 at 9:29 am
Um, you can highlight multiple textboxes in a row and click "Merge" to make them all into a single textbox.
July 30, 2008 at 8:23 am
It will depend on the situation.
Today's editorial is somewhat anti-stored procedure (I happen to mostly agree with the editorial) and there are comments on the other side of the fence.
http://www.sqlservercentral.com/articles/Editorial/63870/%5B/url%5D
July 30, 2008 at 7:15 am
If you have a Company record with a CompanyID and a Person Record that has a CompanyID representing the company they currently work for, deleting any Comapny record would violate...
July 30, 2008 at 4:39 am
To add another thing to think about...
If you do not index the foreign key field and you DELETE a record in your parent table, the delete will have to scan...
July 29, 2008 at 11:52 am
Are you sure you are not using the Script To option in the menu?
If you are:
Go to Tools -> Options -> Scripting
I think it is the "Include IF NOT EXISTS"...
July 29, 2008 at 11:44 am
Just disconnect the workbook.
In Excel 2007, click the Data tab.
Click connections.
Select the connection (or each connection if there are multiple).
Click remove.
You will not be able to continue to use the...
July 29, 2008 at 8:41 am
If you are using Enterprise Edition reporting services, a data-driven subscription will do this. You just have to specify a query that returns the list of userid's, dates, and...
July 29, 2008 at 5:00 am
You still have not given us all of the information. I assume the procedure giving you the problem is: [dbo].[pReadyWMSWM_StockBalanceGenIni] Please post the T-SQL for this procedure.
Also, you have...
July 29, 2008 at 4:51 am
Viewing 15 posts - 871 through 885 (of 2,612 total)