We have created local package under data transformation services which will port data from one server to another server and we have scheduled the...
With the help of ALTER TABLE we can disable/Enable a trigger on a table. But how can we find that the trigger is disabled/Enabled. Rushendra
Hai all, I prefer to go for Sql server backup sol i.e Maintenance plan and Backup database etc.. than Veritas Backup Solution. One of my friends...
The output of the below script will helps u to change nvarchar column to varchar column. select "alter table " + isc.table_name + " alter column "...
Hai all, I thought i should not post this question in the forum, however to clear my doubt i am posting this in the forumn. Question is what...
How to convert a varbinary column into a char or varchar column. Rushendra
How to find out an object id with the help of a pageid For ex: Is it possible with the message Could not retrieve row from logical page (0:75839)...
If we create a table like this For ex: CREATE TABLE MYTMP(NO NUMERIC(30,3)) Sql query analyzer will not create and throughs up an error as...
We are using DB Maintenance planner for daily backups and also we have scheduled email notification to my boss. In the report it is displaying...
We are getting the error 625 with severity 20 state 1 Could not retrieve row from logical page (0:75839) by RID because the entry in the offset...
The query is pertaining to ver Sqlserver 7.0 but fms database db_cmptlevel is in 65. One of our colegue written the below query and we are not...
Separate names with a comma.
