Thanks never thought of the RIGHT command can i do it without the reverse command?

Try this....

after creating the table , definition given by you, i am running below:

--This is for the creation of tables, views, sp etc. in all databases in the server

DECLARE @db_names...

Yes it's not inserting anything because i disabled the insert line just to see if you will successfully run the script so i think the problem is with the insert...

How come I can run the script, put the backup to another server in the network which is set as local system account??

Both servers are using local system account is that ok??

Change the highlited below see if it displays the result of the query

amit.vaid (3/4/2008)

---

Hi lester

after creating the table , definition given by you, i am running below:

--This is for the...

Does your backup filename with this kind of format??

DBName_db_YYYYMMDDHHMM.BAK??

If this is what you are asking :

CREATE TABLE [DB_Monitoring] (

[DB_Name] [varchar] (30) ,

[Date_Created] datetime ,

[Compatibility_Level] [int] NULL ,

[File_Path] [varchar] (2500) ,

[Server_Name] [varchar] (30)

) ON [PRIMARY]

GO

CREATE TABLE...

This is for monitoring the Database Creation

INSERT INTO DB_Name.DB_Owner.Table

select name as 'DB Name',

convert(varchar(50),crdate) as 'Date Created',cmptlevel as 'Compatibility Level',

filename as 'File Path',

@@servername as 'Server Name'

from master..sysdatabases

where convert(char(8),crdate,112) >...

Actually after the incident i asked my supervisor to limit the access of the programmers to the prod server. I remember him (programmer) saying about an exe file that...

Sugesh Kumar (2/28/2008)

---

Anything that starts with _WA_Sys is system created index which s used ofr faster retrival by sql server. you need to see if they stil exists and delte...

Thanks for the response guys just found out that a programmer created the stored procedure :D. He was alarmed (because of not notifying us) when i emailed the programmer group...

As stated in the discussions please check all your column types to see if values declared are greater than of equal to the value in the table that you are...

Use the OPENROWSET function

Example:

INSERT INTO (table_name) (column_name)

SELECT *

FROM OPENROWSET

('Microsoft.jet.oledb.4.0','Excel 8.0;Database=(path)','Select column_name FROM [(Sheet_Name)$]')

Change:

1. (table_name) with your table name

2. (column_name) with the column in the table

3. (path) path of the excel...

Use the OPENROWSET function

Example:

INSERT INTO (column_name)

SELECT *

FROM OPENROWSET

('Microsoft.jet.oledb.4.0','Excel 8.0;Database= $]')

Change:

1. with your table name

2. (column_name) with the column in the table

3. path of the...