Reseting Identity Column using SQL

Hi, Can anyone write me a script, how can I reset identity on column? ( I want to start records from 1 again)

Thanks, radco

Take a look at the following pointer:http://msdn2.microsoft.com/en-US/library/ms176057.aspx

Requirements for Sql Server Mobile and Sql Server 2003 interaction

Folks,

I am trying to use .NET 2005 Beta 2 to write an application targeted to a PPC2003 device. I want to use RDA to Push and Pull data from a Sql Server 2003 database.

This communication fails because I do not have sscesa30.dll in the IIS virtual directory from which the data are pulled.

I would like to know exactly what I need to install on the server so that everything is wired up correctly.

I do not really want to install Sql Server 2005 (CPT) on my server. Is there an SDK that I can install there that makes the sscesa30.dll available? Can it be run without any Sql Server 2005 (CPT) requirements?

Thanks in advance.
-Joel Finkel
finkel@.sd-il.comHi,

I am really not aware of SQL Server 2003. SQL Mobile 3.0 works with both SQL Server 2000 and SQL Server 2005.

I believe that you are working with SQL Server 2000? If so read below!

Given that SQL Mobile 3.0 works with SQL Server 2000. That is you can have SQL Server old version but have the SQL Mobile/CE clients with latest version.

This is what is expected infrastructure:

1) Server Box - SQL Server 2000 SP3a or above
2) IIS Box - Install I1, I2 in order.
3) Device - SQL Mobile 3.0 (Can get from Visual Studio 2005)

I1 - http://www.microsoft.com/downloads/details.aspx?FamilyId=09545A2A-3D2A-4811-AFD5-41AF0F6DF2B3&displaylang=en
I2 - http://www.microsoft.com/downloads/details.aspx?familyid=0A6174A4-C009-4768-8284-698C32EC84E3&displaylang=en

Also, please note that IIS & SQL Server can be on one box. In which case only install I2 on SQL Server Box. You do not need to install I1.

Let me know if you need any more information.

Thanks,
Laxmi NRO, MSFT, SQL Mobile

|||

Thanks for your help, but I have run into issues.

Here is my setup:

IIS 6
Sql Server 2000 (SP4)
Windows 2003 Server

Referring to your note, you write:

"Also, please note that IIS & SQL Server can be on one box.
In which case only install I2 on SQL Server Box. You do not
need to install I1."

Howevever:

When I attempt to install I2, it fails because I have not yet installed I1.

When I attempt to install I1, it fails because I am not running
Sql Server 2000 SP3 or SP3a. I am runnning SP4.

This has now become a critical issue. Any help is greatly appreciated.

|||I2 in the above thread is a beta one by which time SP4 was not shipped.
I2 latest version that works with SP4 is shipped with VS 2005.

The web downloads will be updated with the latest version soon.

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Requirements for Sql Server Mobile and Sql Server 2003 interaction

Folks,

I am trying to use .NET 2005 Beta 2 to write an application targeted to a PPC2003 device. I want to use RDA to Push and Pull data from a Sql Server 2003 database.

This communication fails because I do not have sscesa30.dll in the IIS virtual directory from which the data are pulled.

I would like to know exactly what I need to install on the server so that everything is wired up correctly.

I do not really want to install Sql Server 2005 (CPT) on my server. Is there an SDK that I can install there that makes the sscesa30.dll available? Can it be run without any Sql Server 2005 (CPT) requirements?

Thanks in advance.
-Joel Finkel
finkel@.sd-il.comHi,

I am really not aware of SQL Server 2003. SQL Mobile 3.0 works with both SQL Server 2000 and SQL Server 2005.

I believe that you are working with SQL Server 2000? If so read below!

Given that SQL Mobile 3.0 works with SQL Server 2000. That is you can have SQL Server old version but have the SQL Mobile/CE clients with latest version.

This is what is expected infrastructure:

1) Server Box - SQL Server 2000 SP3a or above
2) IIS Box - Install I1, I2 in order.
3) Device - SQL Mobile 3.0 (Can get from Visual Studio 2005)

I1 - http://www.microsoft.com/downloads/details.aspx?FamilyId=09545A2A-3D2A-4811-AFD5-41AF0F6DF2B3&displaylang=en
I2 - http://www.microsoft.com/downloads/details.aspx?familyid=0A6174A4-C009-4768-8284-698C32EC84E3&displaylang=en

Also, please note that IIS & SQL Server can be on one box. In which case only install I2 on SQL Server Box. You do not need to install I1.

Let me know if you need any more information.

Thanks,
Laxmi NRO, MSFT, SQL Mobile|||

Thanks for your help, but I have run into issues.

Here is my setup:

IIS 6
Sql Server 2000 (SP4)
Windows 2003 Server

Referring to your note, you write:

"Also, please note that IIS & SQL Server can be on one box.
In which case only install I2 on SQL Server Box. You do not
need to install I1."

Howevever:

When I attempt to install I2, it fails because I have not yet installed I1.

When I attempt to install I1, it fails because I am not running
Sql Server 2000 SP3 or SP3a. I am runnning SP4.

This has now become a critical issue. Any help is greatly appreciated.

|||I2 in the above thread is a beta one by which time SP4 was not shipped.
I2 latest version that works with SP4 is shipped with VS 2005.

The web downloads will be updated with the latest version soon.

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Requirements for Sql Server Mobile and Sql Server 2003 interaction

Folks,

I am trying to use .NET 2005 Beta 2 to write an application targeted to a PPC2003 device. I want to use RDA to Push and Pull data from a Sql Server 2003 database.

This communication fails because I do not have sscesa30.dll in the IIS virtual directory from which the data are pulled.

I would like to know exactly what I need to install on the server so that everything is wired up correctly.

I do not really want to install Sql Server 2005 (CPT) on my server. Is there an SDK that I can install there that makes the sscesa30.dll available? Can it be run without any Sql Server 2005 (CPT) requirements?

Thanks in advance.
-Joel Finkel
finkel@.sd-il.comHi,

I am really not aware of SQL Server 2003. SQL Mobile 3.0 works with both SQL Server 2000 and SQL Server 2005.

I believe that you are working with SQL Server 2000? If so read below!

Given that SQL Mobile 3.0 works with SQL Server 2000. That is you can have SQL Server old version but have the SQL Mobile/CE clients with latest version.

This is what is expected infrastructure:

1) Server Box - SQL Server 2000 SP3a or above
2) IIS Box - Install I1, I2 in order.
3) Device - SQL Mobile 3.0 (Can get from Visual Studio 2005)

I1 - http://www.microsoft.com/downloads/details.aspx?FamilyId=09545A2A-3D2A-4811-AFD5-41AF0F6DF2B3&displaylang=en
I2 - http://www.microsoft.com/downloads/details.aspx?familyid=0A6174A4-C009-4768-8284-698C32EC84E3&displaylang=en

Also, please note that IIS & SQL Server can be on one box. In which case only install I2 on SQL Server Box. You do not need to install I1.

Let me know if you need any more information.

Thanks,
Laxmi NRO, MSFT, SQL Mobile|||

Thanks for your help, but I have run into issues.

Here is my setup:

IIS 6
Sql Server 2000 (SP4)
Windows 2003 Server

Referring to your note, you write:

"Also, please note that IIS & SQL Server can be on one box.
In which case only install I2 on SQL Server Box. You do not
need to install I1."

Howevever:

When I attempt to install I2, it fails because I have not yet installed I1.

When I attempt to install I1, it fails because I am not running
Sql Server 2000 SP3 or SP3a. I am runnning SP4.

This has now become a critical issue. Any help is greatly appreciated.

|||I2 in the above thread is a beta one by which time SP4 was not shipped.
I2 latest version that works with SP4 is shipped with VS 2005.

The web downloads will be updated with the latest version soon.

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Require help writing a function

Hi there
I am trying to write a function which will return the Maximum value in a
field of a given table and have run into problems.
I want to pass the name of the field and the name of the table to the
function, have it find the Max value and then add 1 to that number and
return the result.
After doing some reading I thought a Simple Scalar Function would be the way
to go but I just cannot make it work.
Could anyone help me please.
Thanks
June
hi June,
"June Macleod" <junework@.hotmail.com> ha scritto nel messaggio
news:esYBukT4EHA.2568@.TK2MSFTNGP10.phx.gbl
> Hi there
> I am trying to write a function which will return the Maximum value
> in a field of a given table and have run into problems.
> I want to pass the name of the field and the name of the table to the
> function, have it find the Max value and then add 1 to that number and
> return the result.
> After doing some reading I thought a Simple Scalar Function would be
> the way to go but I just cannot make it work.
>
what you want to do is known as Dynamic SQL, which provides poor
performances and security holes toubles...
for your informatgion, please have a look at
http://www.sommarskog.se/dynamic_sql.html for a great explanation of it's
uses and related troubles... and something like
CREATE FUNCTION dbo.udfNextValue (
@.col VARCHAR(10) ,
@.tbl VARCHAR (10)
) RETURNS INT
AS BEGIN
DECLARE @.cmd NVARCHAR
DECLARE @.Value INT
SET @.cmd ='SELECT @.Value = ISNULL(MAX(' + @.col + ') , 0) + 1 FROM ' + @.tbl
EXEC sp_executesql @.cmd, N'@.Value INT OUTPUT', @.Value OUTPUT
RETURN (@.Value)
END
is unfortunately not permitted within user defined function...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

ReportWriter - Soft Artisans

Anyone have any comments on using SoftArtisans ReportWriter that allows
Word/Excel users to write reports and publish to Reporting Services?
Is it very expensive?
is it worth it?"dm1608" wrote:
> Anyone have any comments on using SoftArtisans ReportWriter that allows
> Word/Excel users to write reports and publish to Reporting Services?
Ha! Funny, see a few subject headings down from this post regarding "Excel
reports to RS."
> Is it very expensive?
>
Yes.
> is it worth it?
>
Not really sure yet. I'm asking the same question, although in finer
granularity.
All the best!
Greg--|||"dm1608" wrote:
> Anyone have any comments on using SoftArtisans ReportWriter that allows
> Word/Excel users to write reports and publish to Reporting Services?
> Is it very expensive?
yes, it is expensive.. 7.500 Euro per cpu
> is it worth it?
no, you must redesign all your reports using ms word with the softartisans
addin, if you want to export the reports to word...
And by the Way, i mean the Support by softartisans ist very bad|||So we have SQL Reporting Services in SQL 2000 and 2005. The feature matrix
on SQL 2005 says rendering formats for output are the same: Excel, PDF,
DHTML, images... but still no support for Word.
Does this mean Microsoft itself is shying away from its own product, Word,
by not offering native support within SQL RS? Is there a new industry
standard in word processing that I need to be looking at?
I find it truly mind-boggling for Microsoft to not export to Excel, XML,
even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
only tool available... ?
Any other products out there?
Thanks,
Andrew Puente
"cwalloch" wrote:
>
> "dm1608" wrote:
> > Anyone have any comments on using SoftArtisans ReportWriter that allows
> > Word/Excel users to write reports and publish to Reporting Services?
> >
> > Is it very expensive?
> yes, it is expensive.. 7.500 Euro per cpu
> >
> > is it worth it?
> no, you must redesign all your reports using ms word with the softartisans
> addin, if you want to export the reports to word...
> And by the Way, i mean the Support by softartisans ist very bad|||And before I get crucified, let me revise my last paragraph:
I find it truly mind-boggling for Microsoft to export to Excel, XML,
even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
only tool available... ?
It's called Proofreading 101. I failed that course, apparently. :-)
Cheers,
Andrew Puente
"Andrew Puente" wrote:
> So we have SQL Reporting Services in SQL 2000 and 2005. The feature matrix
> on SQL 2005 says rendering formats for output are the same: Excel, PDF,
> DHTML, images... but still no support for Word.
> Does this mean Microsoft itself is shying away from its own product, Word,
> by not offering native support within SQL RS? Is there a new industry
> standard in word processing that I need to be looking at?
> I find it truly mind-boggling for Microsoft to not export to Excel, XML,
> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
> only tool available... ?
> Any other products out there?
> Thanks,
> Andrew Puente
> "cwalloch" wrote:
> >
> >
> > "dm1608" wrote:
> >
> > > Anyone have any comments on using SoftArtisans ReportWriter that allows
> > > Word/Excel users to write reports and publish to Reporting Services?
> > >
> > > Is it very expensive?
> > yes, it is expensive.. 7.500 Euro per cpu
> >
> > >
> > > is it worth it?
> > no, you must redesign all your reports using ms word with the softartisans
> > addin, if you want to export the reports to word...
> > And by the Way, i mean the Support by softartisans ist very bad|||I suspect that XPS format and office 12 xml formats will be supported when
released.
--
William Stacey [MVP]
"Andrew Puente" <AndrewPuente@.discussions.microsoft.com> wrote in message
news:1B3A18C9-17C9-4135-B367-5E05253C067A@.microsoft.com...
> And before I get crucified, let me revise my last paragraph:
> I find it truly mind-boggling for Microsoft to export to Excel, XML,
> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be
> the
> only tool available... ?
> It's called Proofreading 101. I failed that course, apparently. :-)
> Cheers,
> Andrew Puente
>
> "Andrew Puente" wrote:
>> So we have SQL Reporting Services in SQL 2000 and 2005. The feature
>> matrix
>> on SQL 2005 says rendering formats for output are the same: Excel, PDF,
>> DHTML, images... but still no support for Word.
>> Does this mean Microsoft itself is shying away from its own product,
>> Word,
>> by not offering native support within SQL RS? Is there a new industry
>> standard in word processing that I need to be looking at?
>> I find it truly mind-boggling for Microsoft to not export to Excel, XML,
>> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be
>> the
>> only tool available... ?
>> Any other products out there?
>> Thanks,
>> Andrew Puente
>> "cwalloch" wrote:
>> >
>> >
>> > "dm1608" wrote:
>> >
>> > > Anyone have any comments on using SoftArtisans ReportWriter that
>> > > allows
>> > > Word/Excel users to write reports and publish to Reporting Services?
>> > >
>> > > Is it very expensive?
>> > yes, it is expensive.. 7.500 Euro per cpu
>> >
>> > >
>> > > is it worth it?
>> > no, you must redesign all your reports using ms word with the
>> > softartisans
>> > addin, if you want to export the reports to word...
>> > And by the Way, i mean the Support by softartisans ist very bad