Viewing 15 posts - 16 through 30 (of 57 total)
February 25, 2009 at 4:32 am
oracle *spit* does. not sure about the others.
February 25, 2009 at 4:19 am
sql server only uses after and instead of triggers.
February 25, 2009 at 3:57 am
select * into your_table_name from master.sys.sysprocesses
where spid > 50
February 25, 2009 at 1:53 am
select db_name(database_id),type_desc,physical_name from sys.master_files
February 24, 2009 at 3:56 am
check that the instance you are connecting to has a database called system on it.
February 19, 2009 at 3:32 am
you need a linked server from sql server to oracle? this link goes through the basics.
http://www.sqlmag.com/Articles/ArticleID/49687/49687.html?Ad=1
February 19, 2009 at 3:26 am
have you tried enabling an email session? you can set up database mail in SSMS under management - database mail. you need to create a profile and an...
February 18, 2009 at 6:10 am
Logical file 'Hosp' is not part of database 'Rollout_Hosp'. Use RESTORE FILELISTONLY to list the logical file names.
this looks like your problem. does the database you took the backup...
February 18, 2009 at 6:03 am
your filegroup is full. when you run the query below are do any of the rows have a size and max_size that are the same?
select data_space_id, name, size, max_size,...
February 12, 2009 at 2:51 am
February 5, 2009 at 9:49 am
February 5, 2009 at 4:09 am
you could use the following sql to get the session ids and then create a cursor to kill each spid
select spid from sysprocesses
where db_name(dbid) = @database_name
February 4, 2009 at 8:12 am
this seems to work for me
select table_name, column_name, numeric_precision, numeric_scale
from INFORMATION_SCHEMA.COLUMNS
where table_name = table_name
January 30, 2009 at 8:20 am
Viewing 15 posts - 16 through 30 (of 57 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy