|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Outlook 2003 <--> SQL Server 2005 Posted by RosH at 4/6/2007 10:49:43 PM I was able to build the following code with the help of some help
topics from Microsoft site for Outlook programming. But unfortunately
errors keep on following me. I have included the code and the error
below. I would appreciate you to comment on it.
My intention is to create a macro in out...more >>
SQL2005 ANSI compliant? Posted by Ant at 4/6/2007 4:36:02 PM Hi,
I haven't started using SQL2005 yet but by the look of some answers here
it's quite different to the old TSQL. Is it ANSI compliant? Will the same
script work in other Databases? Just wondering.
Thanks for your thoughts
Ant...more >>
Taking work home. Posted by Mike Labosh at 4/6/2007 4:21:53 PM I was recommending to some students today, a standard developer workstation
configuration, and one of my most stressed recommended items was either SQL
Server or MSDE.
Then, as a developer, I can have acopy of the data warehouse schema (not the
data, just the empty schema). That way, when I h...more >>
Debug T-SQL in VS 2005 Posted by Bob at 4/6/2007 2:46:43 PM Hi,
Despite adding various users to the sysadmin account, performing
admin gymnastics, and researching the issue on the Internet for
several, I cannot 'step into' a SP in the VS 2005 environment.
Both the server instance and VS [Developer Edition] are on the same
machine.
Any suggestion...more >>
When to Add Column to SQL Server Table Posted by Tom LeBold at 4/6/2007 2:12:00 PM Recommended time to add a column to an SQL Server table.
Should adding a column to an SQL Server table be done
while users are updating the table or only when all user are
not using the database or does it matter. This is an Access 2003
database with a back end SQL Server 2000 database....more >>
Maintenance Plan Could not be Parsed Posted by Emma at 4/6/2007 1:58:00 PM I am trying to modify a Maintenance plan in 2000 and I get a message stating
that "the job...could not be parsed". How do I correct this or what do I do?
Thanks,
Emma...more >>
SQL 2005 Rebuild Index dosn't help fragmentation percent go down Posted by SQL at 4/6/2007 12:14:01 PM I have a clustered index on a table with 594032 rows. Fill factor is 0.
avg_fragmentation_in_percent is 62 and the same even after rebuilding the
index.
I also tried UPDATE STATISTICS and no change. When I run the query below, I
get 2 rows - index_level 1 the avg_fragmentation_in_percent is 6...more >>
Inserting from multiple tables into one Posted by Deki at 4/6/2007 10:54:02 AM valuesHello,
I have destination table (tbResult) with 170 columns and 40 tables that I
want to inset into tbResult. My problem is that those 40 tables don't have
same amount of columns as tbResult. Some have 40, some 50, etc. but tbResult
has all posible columns other tables may have.
How ca...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Challenging Query - Please Help Posted by Murali at 4/6/2007 9:08:03 AM Hi,
We have a tough situation when we migrated one of the view from SQL Server
2000 to SQL Server 2005, we have seen CPU hogging around 100% when we access
this particulat view. It works fine in SQL 2000 but has CPU hogging in SQL
Server 2005. This is the view definition
SELECT CASE WHEN...more >>
Databases on Server Posted by Emma at 4/6/2007 6:38:01 AM What is the best way to get a list of all the databases on a server, showing
where the data files and log files are installed?
Thanks
...more >>
Select Query in SQL Server 2000 Posted by Ryan at 4/6/2007 6:20:02 AM CREATE TABLE [dbo].[Category](
[CatID] [nvarchar](16) NOT NULL,
[CatType] [nvarchar](10) NOT NULL,
[CatVal] [smallint] NOT NULL
)
insert into dbo.Category values('A1', 'A', 2)
insert into dbo.Category values('A1', 'B', 3)
insert into dbo.Category values('A1', 'C', 1)
insert into ...more >>
Dynamic sort issue Posted by NAVIN.D at 4/6/2007 5:28:01 AM Need to do dynamic sort on this query and using declare tables. Included the
error i get.
Declare @Rulename varchar(255)
Declare @Hostname varchar(255)
Declare @Environment varchar(255)
Declare @Serverowner varchar(255)
Declare @Priority varchar(255)
select @Rulename ='All'
select @Host...more >>
Dynamic parameter value for sp_executesql Posted by Andrew at 4/6/2007 2:31:33 AM Hy everybody
I want to create a dynamic query using the internal sp_executeSQL, but
passing and params' argument a parameter's value of the calling stored
procedure? Is this possible?
For example I've this code:
create PROCEDURE [dbo].[ADDRESS_INSERT]
(
@P_ADR_ID uniqueidentifier
, @P_...more >>
Need help to create this.... Posted by Danka at 4/6/2007 12:17:39 AM I have three tables "customer", "customer_address" and "customer_phone" from
a old production system. A customer can have more than one address with more
than one phone number type (voice and fax) on each address. I know it does
not make any sense to set it up like this. However I need to crea...more >>
Service Broker conversation example wanted Posted by yapann at 4/6/2007 12:00:00 AM
Hey
Anyone could share any working example (complete, entire script(s) rather
then a webpage) of Service Broker conversation? I wrote my script days ago,
and I really cannot find why it cannot see remote instance to talk to.
I even got really great book by Itzik (Inside SQL Server 20...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |