Hello:
I have setup a sqltrace to trace another sql server and
write to local sql table. I have try to defind the
template but it can't save the trace server and write to
local sql table. Is it possible to execute the sql trace
by simple way?
Thanks!
It's never a good idea to trace and have it write directly to a table. You
should always have it write to a file on a locally attached drive. You can
then easily import the file into a table later. This way you will have the
least amount of impact on the server while tracing. See the following and
the associated sp's in BooksOnLine.
sp_trace_create
fn_trace_gettable
Andrew J. Kelly SQL MVP
"Alan" <anonymous@.discussions.microsoft.com> wrote in message
news:2ef801c4a22e$3624e740$a601280a@.phx.gbl...
> Hello:
> I have setup a sqltrace to trace another sql server and
> write to local sql table. I have try to defind the
> template but it can't save the trace server and write to
> local sql table. Is it possible to execute the sql trace
> by simple way?
> Thanks!
sql
Showing posts with label cant. Show all posts
Showing posts with label cant. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
Help on #911 Cant locate entry in sysdatabases...
Could not locate entry in sysdatabases for database 'TEST'. No entry found with that name. Make sure that the name is entered correctly.
I got the above error from time to time and like to do some troubleshooting and in vain...hope I can get some help or hints here...
Thanks a lot.
WDid you rename the database ? Which version of sql server are you using ? Is it your login that receives this error or other logins ?|||I have a new database and use it for a library server and through the installation program, it will create admin account on sql server for that database...at this point, I got the above error. I didn't do anything to the new database...
Can't see anything strange in Profiler...anyone out there can help?|||What are the details of the installation program/process ?
I got the above error from time to time and like to do some troubleshooting and in vain...hope I can get some help or hints here...
Thanks a lot.
WDid you rename the database ? Which version of sql server are you using ? Is it your login that receives this error or other logins ?|||I have a new database and use it for a library server and through the installation program, it will create admin account on sql server for that database...at this point, I got the above error. I didn't do anything to the new database...
Can't see anything strange in Profiler...anyone out there can help?|||What are the details of the installation program/process ?
Sunday, February 19, 2012
Help me get MSDE SP3a installed on Win Server 2003
I've tried every which way I can from the docs and but I can't seem to get MSDE to install correctly. Found out that Win2003 only runs SP3a, downloaded and tried it.
tried these different commands from the prompt:
setup SAPWD="xxxxx" INSTANCENAME="xxxxx" TARGETDIR="xxxx" (from MSDE2000 only)
setup /upgradesp sqlrun INSTANCENAME="xxxxx" DISABLENETWORKPROTOCOLS=1 (after installing MSDE2000 first)
setup INSTANCENAME="xxxxx" SAPWD="xxxxx" (straight from MSDE2000 SP3a)
Services shows that the SQL agent and the MSSQL$xxxx running. MSSQLServerADHelper is not running. The Service Manager isn't showing any services in the tray nor does it have the little green arrow. I can't connect to anything with Enterprise Manager eithe
r.
What do I need to do? Please note, I'm a totally complete noob with SQL admin and set up...
Thanks...
PS: and note that I'm in the correct directory with the installer and the xxxx are the correct instances and pw's
addition: This is Win 2003 Server Standard Edition...
tried these different commands from the prompt:
setup SAPWD="xxxxx" INSTANCENAME="xxxxx" TARGETDIR="xxxx" (from MSDE2000 only)
setup /upgradesp sqlrun INSTANCENAME="xxxxx" DISABLENETWORKPROTOCOLS=1 (after installing MSDE2000 first)
setup INSTANCENAME="xxxxx" SAPWD="xxxxx" (straight from MSDE2000 SP3a)
Services shows that the SQL agent and the MSSQL$xxxx running. MSSQLServerADHelper is not running. The Service Manager isn't showing any services in the tray nor does it have the little green arrow. I can't connect to anything with Enterprise Manager eithe
r.
What do I need to do? Please note, I'm a totally complete noob with SQL admin and set up...
Thanks...
PS: and note that I'm in the correct directory with the installer and the xxxx are the correct instances and pw's
addition: This is Win 2003 Server Standard Edition...
Subscribe to:
Comments (Atom)