Viewing 15 posts - 18,586 through 18,600 (of 26,484 total)
You may want to spend a little time reading about sp_executesql in BOL (Books Online). Based on the example there this is the code I came up with, but...
October 28, 2009 at 12:46 pm
Need to ask why? Presentation of datetime values should be handled by the UI.
October 28, 2009 at 12:35 pm
Is there a trigger on the dbo.Lead table that may be causing a rollback of the transaction? Are you getting any kind of error message?
October 28, 2009 at 10:15 am
Flo,
You indicated that this is an x86 version (32-bit) of SQL Server 2005 and that PAE is enabled on the OS, is AWE enabled for SQL Server 2005?
Is the server...
October 28, 2009 at 9:50 am
robin-892784 (10/28/2009)
This restore does drop the old DB and restores the new one...unfortunately I can't alter the restore method.
I have to ask, but why can't you modify the restore method?...
October 28, 2009 at 9:46 am
Gift Peddie (10/27/2009)
That is very good example but you will find most T-SQL developers write the old one even in SQL Server 2005 and 2008 and SQL Server in most...
October 27, 2009 at 4:36 pm
Gift Peddie (10/27/2009)
Only with regard to INNER JOINs. The old style OUTER JOINs are not supported in SQL Server 2005 and later (compatibility mode 90 and >).
I am not talking...
October 27, 2009 at 3:19 pm
Gift Peddie (10/27/2009)
I had a multi-table query with a left join against some of the tables, one table in particular was not referenced (yet) in the select nor in...
October 27, 2009 at 2:58 pm
I have to agree that experience is extremely helpful. You learn about things that you may not have known about otherwise. I have experience in computer operations, systems...
October 27, 2009 at 2:56 pm
Alvin Ramard (10/27/2009)
Jack Corbett (10/27/2009)
October 27, 2009 at 2:33 pm
J-F Bergeron (10/27/2009)
October 27, 2009 at 2:32 pm
I just did a little research myself and it appears that w3wp.exe is part of IIS.
October 27, 2009 at 1:55 pm
Gift Peddie (10/27/2009)
But we aren't talking about ANSI Standard. We are talking about MS SQL Server and most of us will use the features and capabilities of MS SQL Server...
October 27, 2009 at 1:33 pm
Please read the first article I reference below in my signature block regarding asking for assistance. Follow the instructions in that article regaring posting the DDL (CREATE TABLE statements),...
October 27, 2009 at 1:28 pm
The problem with your question is that there isn't enough information to actually give you an answer. We really need more information to help you.
October 27, 2009 at 1:21 pm
Viewing 15 posts - 18,586 through 18,600 (of 26,484 total)