I use VS.NET for all my database objects, not only SP's. If you select all your tables, views, ect in your database, right-click and choose "Generate Script..", you can make scripts for all your objects. Just choose a map that is part of your database project, and VS.NET takes care of the source control part […]
2003-06-16
1 reads
I like the "break all his fingers" option. but I suppose this may not fly with his boss, although my boss would probably do it for me . Thank you for your posts, I will investigate the link. Thanks for your tip on removing guest from this database. I will investigate if he is still […]
2003-06-13
2 reads
If you change them in both then you won't have any problems. The next time the snapshot agents runs, it will create a snapshot with the new data types and apply them to the subscribers. you should change both data types in both serves before the agent runs.
2003-06-12
1 reads
Hello amelvin, quote: declare @SQL set @SQL='select * from tablea where columnb in (' + @SomeVariable + ')' exec sp_executesql @SQL that was also my intention, however from some quick testing, it only seems to work with an consecutive numbering Cheers, Frank
2003-06-11
1 reads
Here's the problem: WHERE (LEDef_ActiveInd = 1) OR(LEDef_ActiveInd = 1) AND (LEDef_Cd LIKE '10%') You are asking: Give me LEDef_ActiveInd = 1, OR give me (LEDef_ActiveInd = 1) AND (LEDef_Cd LIKE '10%'). So, when it finds LEDef_ActiveInd = 1 it says okay...here's what you want, I quit. So the second part of the OR is […]
2003-06-10
Hi Affan, Are you saying that you want the time (HH:MM:SS) in your time dimension in your cube(s)? If yes,then the member counts on this dimension are likely to be large, especially if you include all times within a day at say the minute level. Alternatively, you could put time of day into a separate […]
2003-06-05
Did you try opening it up from another computer (i.e. another Client Tools installation)? If so, how are your msdb backups? I can't think of anything other than a restore of the msdb to get them back if you can't open the package from anywhere. May be worth a call to MS if it is […]
2003-06-05
First you are going to have to detach the db using <b>sp_detach_db</b>. Then move the log to the new location and use <b>sp_attach_db</b>. The easiest way to do this is to open up SQL Query Analyzer and run these procedures. Look up on technet.com and/or MSDN for a description on how to use these procs. […]
2003-06-04
2 reads
Marty You say that you would like to place this functionality into a User Defined Function, however there are a number of issues to consider about using something like this in a function. 1. Scaler Functions The main problem you have with a scaler function in this situation is that thay can return only a […]
2003-06-03
I would use a BIT field (1/0). You can use a Varchar(3) or CHAR(3) and insert Yes / No. Useing a CHAR(3) will "waste" space as it'll pad the right with a space when you have a no. Bit is the best option. Cheers, Crispin
2003-05-22
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers