We have created local package under data transformation services
which will port data from one server to another server and we have
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.
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
select "alter table " + isc.table_name + " alter column "...
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.
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
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
One of our colegue written the below query and we are not...
Separate names with a comma.