Thanx,Since there is only one autoincrement column per table, you can use SELECT IDENT_CURRENT('table_name') Tim S
> It seems MS changed the way syscolumns table works. It appears this is
> no longer a table, but probably a systemview. Problem is, it looks like
> the autoval column is no longer working. I was using this to determine
> whether a column was an auto incrementing identity field. How should I
> go about determining a column's auto increment values? >
> Thanx,
>|||Have you tried COLUMNPROPERTY ( id , column , property )IsIdentity
using
Showing posts with label appears. Show all posts
Showing posts with label appears. Show all posts
Monday, March 19, 2012
Changes in SQL2005 syscolumns table
It seems MS changed the way syscolumns table works. It appears this is no longer a table, but probably a systemview. Problem is, it looks like the autoval column is no longer working. I was using this to determine whether a column was an auto incrementing identity field. How should I go about determining a column's auto increment values?
Changes in SQL2005 syscolumns table
It seems MS changed the way syscolumns table works. It appears this is no longer a table, but probably a systemview. Problem is, it looks like the autoval column is no longer working. I was using this to determine whether a column was an auto incrementing identity field. How should I go about determining a column's auto increment values?
Thanx,Since there is only one autoincrement column per table, you can use SELECT
IDENT_CURRENT('table_name') news:8bf47d13-a87f-4304-b0d6-9eae8685e164@.discussions.microsoft.com... > It seems MS changed the way syscolumns table works. It appears this is > no longer a table, but probably a systemview. Problem is, it looks like > the autoval column is no longer working. I was using this to determine > whether a column was an auto incrementing identity field. How should I > go about determining a column's auto increment values? > > Thanx, >|||Have you tried Tim SCOLUMNPROPERTY ( id , column , property )IsIdentity
using
Wednesday, March 7, 2012
Change the domain setting for the MS SQL 2000 Server
Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
James
To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>
|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights[vbcol=seagreen]
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in
>
>.
>
|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
James
To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>
|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights[vbcol=seagreen]
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in
>
>.
>
|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in
Change the domain setting for the MS SQL 2000 Server
Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesHello,
If you bring up "Services" on your Server machine and have
a look for the SQL Server service, you can change the
account though there.
Remember to stop and start it after you have finished.
Peter
"Choose a job you love, and you will never have to work a
day in your life. "
Confucius
>--Original Message--
>Hallo,
>During the installation I have to choose the proper
service accounts. On a
>form that appears, I can set the service setting to use
local system account
>or to use a domain user account.
>I would like to use the domain user account to allow
other apllication to
>query the SQL server. But latter on I would like to
change the domain.
>Where to change the domain setting before put the the SQL
srver machine in
>another domain?
>Thanks in advance
>James
>.
>|||To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
>> Hallo,
>> During the installation I have to choose the proper
service accounts. On a
>> form that appears, I can set the service setting to use
local system
>account
>> or to use a domain user account.
>> I would like to use the domain user account to allow
other apllication to
>> query the SQL server. But latter on I would like to
change the domain.
>> Where to change the domain setting before put the the
SQL srver machine in
>> another domain?
>> Thanks in advance
>> James
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> >--Original Message--
> >To add to Peter's response, you can also change the
> service account using
> >Enterprise Manager. This will assign the account the
> advanced user rights
> >needed.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"James" <James@.discussions.microsoft.com> wrote in message
> >news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> >> Hallo,
> >>
> >> During the installation I have to choose the proper
> service accounts. On a
> >> form that appears, I can set the service setting to use
> local system
> >account
> >> or to use a domain user account.
> >> I would like to use the domain user account to allow
> other apllication to
> >> query the SQL server. But latter on I would like to
> change the domain.
> >> Where to change the domain setting before put the the
> SQL srver machine in
> >> another domain?
> >>
> >> Thanks in advance
> >>
> >> James
> >>
> >
> >
> >.
> >
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesHello,
If you bring up "Services" on your Server machine and have
a look for the SQL Server service, you can change the
account though there.
Remember to stop and start it after you have finished.
Peter
"Choose a job you love, and you will never have to work a
day in your life. "
Confucius
>--Original Message--
>Hallo,
>During the installation I have to choose the proper
service accounts. On a
>form that appears, I can set the service setting to use
local system account
>or to use a domain user account.
>I would like to use the domain user account to allow
other apllication to
>query the SQL server. But latter on I would like to
change the domain.
>Where to change the domain setting before put the the SQL
srver machine in
>another domain?
>Thanks in advance
>James
>.
>|||To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
>> Hallo,
>> During the installation I have to choose the proper
service accounts. On a
>> form that appears, I can set the service setting to use
local system
>account
>> or to use a domain user account.
>> I would like to use the domain user account to allow
other apllication to
>> query the SQL server. But latter on I would like to
change the domain.
>> Where to change the domain setting before put the the
SQL srver machine in
>> another domain?
>> Thanks in advance
>> James
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> >--Original Message--
> >To add to Peter's response, you can also change the
> service account using
> >Enterprise Manager. This will assign the account the
> advanced user rights
> >needed.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"James" <James@.discussions.microsoft.com> wrote in message
> >news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> >> Hallo,
> >>
> >> During the installation I have to choose the proper
> service accounts. On a
> >> form that appears, I can set the service setting to use
> local system
> >account
> >> or to use a domain user account.
> >> I would like to use the domain user account to allow
> other apllication to
> >> query the SQL server. But latter on I would like to
> change the domain.
> >> Where to change the domain setting before put the the
> SQL srver machine in
> >> another domain?
> >>
> >> Thanks in advance
> >>
> >> James
> >>
> >
> >
> >.
> >
Change the domain setting for the MS SQL 2000 Server
Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesTo add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in[vbcol=seagreen]
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesTo add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in[vbcol=seagreen]
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in
change the default navigation bar
Is it possible to change the default navigation bar that appears in
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.Sorry for the double posting..... :-(
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.Sorry for the double posting..... :-(
Change the default navigation bar
Is it possible to change the default navigation bar that appears in
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.&rc:Toolbar=false in the url, removes it
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> Is it possible to change the default navigation bar that appears in
> Reporting Services?
> The Navigation bar that allows, page movement, viewing size, Export
> etc.
>|||Thanks for the tip, but I need to create my own now, any ideas?|||I don't think there's a way. There could be a way to change the colors and
fonts, but I don't think you can change the structure.
And it's all messed up for firefox, or netscape. I check the browser before
I call the reports, and turn the toolbar off, if it's not IE.
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112871211.962325.310910@.l41g2000cwc.googlegroups.com...
> Thanks for the tip, but I need to create my own now, any ideas?
>|||"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
hmm... that doesn't seem to work for me. my url reads:
http://MyServer/Reports/Pages/Report.aspx?ItemPath=%2fMy+Report&rc:Toolbar=False&rc:Parameters=false
but both the toolbar and the parameters pane show up just the same... what
am I doing wrong? also, how can I specify that the toolbar not be displayed
after the user presses the "View Report" button (since I obviously don't have
control over the URL at that point)?|||but I just want to remove the navigation bar, and keep the parameters bar ...
the URL:
..?&rc:toolbar=false&rc:parameters=true
doesnt work ...
How do it ?...
"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
> "Bryan Avery" <b_avery@.yahoo.com> wrote in message
> news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> > Is it possible to change the default navigation bar that appears in
> > Reporting Services?
> >
> > The Navigation bar that allows, page movement, viewing size, Export
> > etc.
> >
>
>
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.&rc:Toolbar=false in the url, removes it
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> Is it possible to change the default navigation bar that appears in
> Reporting Services?
> The Navigation bar that allows, page movement, viewing size, Export
> etc.
>|||Thanks for the tip, but I need to create my own now, any ideas?|||I don't think there's a way. There could be a way to change the colors and
fonts, but I don't think you can change the structure.
And it's all messed up for firefox, or netscape. I check the browser before
I call the reports, and turn the toolbar off, if it's not IE.
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112871211.962325.310910@.l41g2000cwc.googlegroups.com...
> Thanks for the tip, but I need to create my own now, any ideas?
>|||"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
hmm... that doesn't seem to work for me. my url reads:
http://MyServer/Reports/Pages/Report.aspx?ItemPath=%2fMy+Report&rc:Toolbar=False&rc:Parameters=false
but both the toolbar and the parameters pane show up just the same... what
am I doing wrong? also, how can I specify that the toolbar not be displayed
after the user presses the "View Report" button (since I obviously don't have
control over the URL at that point)?|||but I just want to remove the navigation bar, and keep the parameters bar ...
the URL:
..?&rc:toolbar=false&rc:parameters=true
doesnt work ...
How do it ?...
"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
> "Bryan Avery" <b_avery@.yahoo.com> wrote in message
> news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> > Is it possible to change the default navigation bar that appears in
> > Reporting Services?
> >
> > The Navigation bar that allows, page movement, viewing size, Export
> > etc.
> >
>
>
Subscribe to:
Posts (Atom)