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)