Dear Friends, There is an ungent opening in MEP a well reputed MNC, Located in Madhapur, requires a IT professional having more that 2 years experience in SQL...
Hi, We have migrated our production server to SQL 2005 64 Bit SP 1 . Previously it was on SQL 2000, 32 X and service pack 3a. Now the problem is that, our...
Hi As you cannot restore higher version (2005) dump on small version(2000) cheers Saurabh Aggarwal(9818208205) ... Saurabh Aggarwal [Non-text portions of this...
Saurabh Aggarwal
saurabhagg1@...
May 1, 2006 5:42 pm
3405
Try this one
sp_helpobject table_name
On Sat, 29 Apr 2006 sunil john wrote :
>can any one tell me what is the syntax for viewing the structure of the...
Saurabh Aggarwal
saurabhagg1@...
May 1, 2006 5:43 pm
3406
Hi is it ok to run the stored procedure sp_updatestats with users connected to the database? Maybe, during low activity, but anyway with users connected? Any...
Just check again, whether hard disk drive letter {D} your specifying are correct or not. There is not any other reason for this, do one thing try to restore...
Hi Saurabh, I do not think this is the case. I have restored a test database for R&D purpose with 2 tables in SQL 2000 from SQL 2005. Anyhow, is there any...
Hi Virender , I tried to restore after creating Backup Device from SQL Server Management Studio(2005 Tool). But it also gives me the same error message. ...
Dear all, Experts please help me in this... i want to combain there two query and get the result.. select CONVERT(varchar,timecreated,111), count(da) from...
Try sp_help <table_name> OR just press ALT+F1 after selecting the table name. Regards Roji. P. Thomas http://toponewithties.blogspot.com ... From: sunil john ...
Sunil, Try this Select A.dates, sum(a.counts) From (select CONVERT(varchar,timecreated,111) as dates , count(da) as counts from FarouhaMTMessage FM(nolock) ...
Madhu, I dont think it is possible. The only way you can do this is like you can replicate the data or you have to manually export and import the data. There...
can u tru this ' declare @sql varchar(1000) set @sql 'select timecreated,aas from (select '+CONVERT(varchar,timecreated,111)+ ' as timecreated, count(da) aas...
what is ur profile...means working as what? pallavi b <pallavi_br2005@...> wrote: Hi I am Pallavi, i am new member of this group. thanks regads pallavi ...
Is there any t-sql script to script out all the users or logins and their roles and permissions? With Smiles Santhosh S.J. Failure Means Delay Not Defeat ... ...
Lekshmy, I have passed your second question to some of my colleagues and they come up with a bunch of solutions. Needless to say, All of them are working :) ...
Please right click on the master database .and then choose the script. form the option only choose the role , log in .. it create all the user and login for...
Radhey, Thanks for your idea. But I asked for a t-sql With Smiles Santhosh S.J. Failure Means Delay Not Defeat ReadMe @ santhoshpakkangal.blogspot.com ... ...
Hi all, I have a couple of questions. Firstly, i need to move a database from access 2000 to sql server 2000. I have never done data migration before. If...
Hi All, Iam on the way of giving microsoft exam 70-229 (Designing and impelementing databases with MS SQL Server 2000 Enterprise). I just passed my exam...
Hi all I have a small doubt in the database file growth option. I want to develop the project for a big organisation.and i want to mention the file growth...
This is a open ended question. This is again how you want to go about it. I have rich experience in Data Migration. I have migrated our organizations' Legacy...
Hi everybody, As Saurabh said, It is clearly mentioned in Book on line and in Microsoft site also that "Backup created by more recent version of SQL can not be...
Here is a rough but very simple way to predict data growth
# Step1
Check the size of your table based on it is structure and field size
# Step 2 Check the...
Also to test the Dataloading and then performance of Database and application.... check out this tool
http://www.datatect.com/index.htm
-----Original...
.mdf got full is there any why to increse or to make some free space for the same with out incresing the size of .mdfeai Team, I have some doubts 1.My .mdf got...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
