Create and access database through ftp

I have to create a website and a database, but I 've only access for the server by ftp.

Is there a possibility to create and run some kind of sql script automaticly if I've only have access via ftp?!

(Using sqlserver 2000)

tia john

No, to the best of my knowledge you cannot run a SQL script solely through FTP. Surely your ISP must give you some sort of interface for creating tables?

CPU Usage pegged at 100%

Last night we had reports that our website was not responding. After some
investigation we found that the issue was SQL Server had all of the CPU's
pegged at 100% on a server that usually runs no higher than 10%. Our site
was not exceptionally busy, nor have we installed anything new that accesses
the database recently. In the sQL Server Error Log I see alot of "buffer
latch errors", but they appear to have occurred after CPU usage had already
hit 100%.
No one here is really a SQL Server troubleshooting or tuning expert. What
should we do to try to determine the cause?
Thank youEvan,
This can be difficult to track down because you really do not have any idea
what was occuring at the time. You might consider creating an automated
proactive solution to tracking these kinds of issues by using Profiler,
jobs, alerts (performance condition alerts included), SysMon, MOM 2005
and/or a related third-party product.
HTH
Jerry
"Evan Nelson" <EvanNelson@.discussions.microsoft.com> wrote in message
news:CB0D7602-453D-4D35-A09C-9672D7B47E29@.microsoft.com...
> Last night we had reports that our website was not responding. After some
> investigation we found that the issue was SQL Server had all of the CPU's
> pegged at 100% on a server that usually runs no higher than 10%. Our site
> was not exceptionally busy, nor have we installed anything new that
> accesses
> the database recently. In the sQL Server Error Log I see alot of "buffer
> latch errors", but they appear to have occurred after CPU usage had
> already
> hit 100%.
> No one here is really a SQL Server troubleshooting or tuning expert. What
> should we do to try to determine the cause?
> Thank you
>|||Try this product eval:
http://www.teratrax.com/tpm/index.html

CPU Usage pegged at 100%

Last night we had reports that our website was not responding. After some
investigation we found that the issue was SQL Server had all of the CPU's
pegged at 100% on a server that usually runs no higher than 10%. Our site
was not exceptionally busy, nor have we installed anything new that accesses
the database recently. In the sQL Server Error Log I see alot of "buffer
latch errors", but they appear to have occurred after CPU usage had already
hit 100%.
No one here is really a SQL Server troubleshooting or tuning expert. What
should we do to try to determine the cause?
Thank you
Evan,
This can be difficult to track down because you really do not have any idea
what was occuring at the time. You might consider creating an automated
proactive solution to tracking these kinds of issues by using Profiler,
jobs, alerts (performance condition alerts included), SysMon, MOM 2005
and/or a related third-party product.
HTH
Jerry
"Evan Nelson" <EvanNelson@.discussions.microsoft.com> wrote in message
news:CB0D7602-453D-4D35-A09C-9672D7B47E29@.microsoft.com...
> Last night we had reports that our website was not responding. After some
> investigation we found that the issue was SQL Server had all of the CPU's
> pegged at 100% on a server that usually runs no higher than 10%. Our site
> was not exceptionally busy, nor have we installed anything new that
> accesses
> the database recently. In the sQL Server Error Log I see alot of "buffer
> latch errors", but they appear to have occurred after CPU usage had
> already
> hit 100%.
> No one here is really a SQL Server troubleshooting or tuning expert. What
> should we do to try to determine the cause?
> Thank you
>
|||Try this product eval:
http://www.teratrax.com/tpm/index.html

CPU Usage pegged at 100%

Last night we had reports that our website was not responding. After some
investigation we found that the issue was SQL Server had all of the CPU's
pegged at 100% on a server that usually runs no higher than 10%. Our site
was not exceptionally busy, nor have we installed anything new that accesses
the database recently. In the sQL Server Error Log I see alot of "buffer
latch errors", but they appear to have occurred after CPU usage had already
hit 100%.
No one here is really a SQL Server troubleshooting or tuning expert. What
should we do to try to determine the cause?
Thank youEvan,
This can be difficult to track down because you really do not have any idea
what was occuring at the time. You might consider creating an automated
proactive solution to tracking these kinds of issues by using Profiler,
jobs, alerts (performance condition alerts included), SysMon, MOM 2005
and/or a related third-party product.
HTH
Jerry
"Evan Nelson" <EvanNelson@.discussions.microsoft.com> wrote in message
news:CB0D7602-453D-4D35-A09C-9672D7B47E29@.microsoft.com...
> Last night we had reports that our website was not responding. After some
> investigation we found that the issue was SQL Server had all of the CPU's
> pegged at 100% on a server that usually runs no higher than 10%. Our site
> was not exceptionally busy, nor have we installed anything new that
> accesses
> the database recently. In the sQL Server Error Log I see alot of "buffer
> latch errors", but they appear to have occurred after CPU usage had
> already
> hit 100%.
> No one here is really a SQL Server troubleshooting or tuning expert. What
> should we do to try to determine the cause?
> Thank you
>|||Try this product eval:
http://www.teratrax.com/tpm/index.html

Counter settings?

I'm changing databases for a website from Access to SQl Server.
In the Access file, the ID column is assign as 'counter' so the value is automaticly raised by 1 when 'Insert'-statement is used.
How is the equivalent made for SQL Server?
I get an error message when I use the 'Insert statement'

Thanks
CalleOriginally posted by Calle
I'm changing databases for a website from Access to SQl Server.
In the Access file, the ID column is assign as 'counter' so the value is automaticly raised by 1 when 'Insert'-statement is used.
How is the equivalent made for SQL Server?
I get an error message when I use the 'Insert statement'

Thanks
Calle

Try changing your ID column to an integer and set the Identity property to Yes (not for replication), set seed to 1 and increment to 1.

This is the same as the Autonumber function in Access.|||I think this has already been done. actually this is the reason for the error. you can remove identity property on the target table and do your insert. once it completes you can reestablish identity(1,1). another way would be to set identity_insert your_table_name on before the insert, and then set it off after insert completes. third way would be to exclude the identity field from being populated. but the last method would assign brand new identity values which may break relationship between tables.